PMCMD Command

1. Scheduling a workflow 
pmcmd command syntax for scheduling the workflow is shown below:
pmcmd scheduleworkflow -service informatica-integration-Service -d domain-name -u user-name -p password -f folder-name -w workflow-name
This command just schedules the workflow for the next run.

2. Start workflow 
The following pmcmd command starts the specified workflow:
pmcmd startworkflow -service informatica-integration-Service -d domain-name -u user-name -p password -f folder-name -w workflow-name
This triggers the work-flow immediately

3. Stop workflow 
Pmcmd command to stop the infromatica workflow is shown below:
pmcmd stopworkflow -service informatica-integration-Service -d domain-name -u user-name -p password -f folder-name -w workflow-name

4. Start workflow from a task 
You can start the workflow from a specified task using the following syntax:
pmcmd startask -service informatica-integration-Service -d domain-name -u user-name -p password -f folder-name -w workflow-name -startfrom task-name

5. Stopping a task. 
The following pmcmd command stops the specified task instance:
pmcmd stoptask -service informatica-integration-Service -d domain-name -u user-name -p password -f folder-name -w workflow-name task-name

6. Aborting workflow 
The following pmcmd commands are used to abort workflow:
pmcmd abortworkflow -service informatica-integration-Service -d domain-name -u user-name -p password -f folder-name -w workflow-name

7. Aborting specific task
The following pmcmd commands are used to abort a specific task in a workflow:
pmcmd aborttask -service informatica-integration-Service -d domain-name -u user-name -p password -f folder-name -w workflow-name task-name

Regards,
Hari Babu

How to calculate count of duplicate records in Informatica?

Source 

Name, no, salary

Hari, 10, 10K

Babu, 20, 30K

Hari, 10, 10k

Naidu, 10, 40k

Target 

Name,No,Salary, count

hari ,10,10k,          2

Babu, 20 ,30K      1

naidu,10 ,40k       1

• Create an expression transformation, connect all ports from source qualifier to expression.

• Add other output port to expression with O_ENAME

• O_ENAME=ENAME

• Create aggregator transformation, connect all ports from expression to aggregator.

• In the aggregator, groupby on all columns

• Write a expression on O_ENAME

• O_ENAME=count(ENAME)

• Connect all ports from aggregator target

• connect O_ENAME to COUNT in target  

output will be 

hari,  10,    10k,     2

Babu, 20 ,30K      1

naidu,10 ,40k       1

Regards,
Hari Babu