Data Transformation Manager in Informatica

There are various actions that DTM process performs, e.g., reading data from source, writing to target, processing transformations, etc. DTM process is started by/kicked off by Integration service process.

Integration Service process provides DTM process with session instance information. DTM process then reads metadata about Session and associated Mapping from repository and then validation process is done.

If Session is using a parameter file, Integration Service process passes parameter file information to the DTM process. DTM is capable of finding out Session Level, Mapping Level and Workflow level parameters and variables using this information.

DTM process also validates all the connection objects associated with Source/Target/Lookups and sees if appropriate execute permissions are available to the user who started the workflow.

Once Connection Object verification is done DTM executes and pre-session and then post-session commands provided.

One of the important functions of DTM process is to create multiple threads to perform various transformations specified in the mapping. DTM process creates separate threads for lookup, readers, writers, etc.

 DTM process is also responsible for creating session logs. Informatica has best logging mechanism where all the errors, transformation status and overall session processing status are logged. This makes Informatica powerful in terms of debugging any issue while executing the session.

DTM process also checks for any post session success or failure emails and processes them accordingly.

Thank you..