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?

  • Interview Candidate
  • 5
  • 5317

Showing Answers 1 - 5 of 5 Answers

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

  Was this answer useful?  Yes

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:

  Was this answer useful?  Yes

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

 

  Was this answer useful?  Yes

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

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.