What is DTM session?

What is DTM session?

 DTM - Stands for Data Transformation Manager. This is a unix process /windows service which runs on Informatica server and does the actual processing of the ETL code.

PMCMD Command

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. Aboting 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

Set Target Load Order in Informatica

Set Target Load Order in Informatica

When we have multiple interdependent data streams (pipelines) in our mapping, we can configure the Load Order of the Targets. This is often done to maintain referential integrity, maintaining consistent data or in a case where the target of first pipeline is source of the second pipeline in the same mapping.

In our example, we have two pipelines, one each for Student and Employee. Target Load Plan can be set at the mapping level in Designer as follows

1.    Open Mapping

 

1.    Go to mappings - Target Load Plan

Adjust the target group load order as per your requirements using Up, Down arrows

4. Click on OK and you are done!

The target load plan shows Source Qualifiers and respective Targets