1. what is DTM process?2. what r the output files that informatica creates during the session running?3. limitations of joiner transformations?under which conditions we can't use joiner transformation?

Rajesh

Oct 10th, 2006

DTM stand for Data Transformation Manager. Primary role of DTM is moving data from source to Target. Session log holds different type of information based on the tracing level set at the runtime.
Regards,
Rajesh

SRAVANGOPISETTY

Oct 10th, 2006

DTM stands for data transformation manager.DTM modifies the data according to the Instructions given by the session Mapping.Output files are:-. Informatica server log: Informatica server (on UNIX) creates a log for all status and error messages (default name: pm.server.log).It also creates an error log for error messages.These files will be created in informatica home directory. Session log file: Session detail file: Performance detail file: Performance detail file: Control file: Post session email: Indicator file: output file: Cache files:

kumar Reddy

Oct 13th, 2006

Usually Workflow Process contains the Following steps.

1. Load Manager Process: Starts and locks the workflow, runs workflow tasks, and start the DTM to run sessions

2. Data Transformation Manager (DTM) process: Performs the session validation. Creates threads to initialize the session, read, write, and transform data, and handle pre and post session parameters

lakshmi1

Oct 16th, 2006

Hi
We can not use joiner when:
1) both pipelines come from the same source
2) both pipelines come from the same normalizer
3)If one pipeline contain an update strategy or a sequence generator ( connected/unconnected )
Regards
lakshmi