Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / atiric sofrware(raja)
DTM process: The Load Manager creates one DTM process for
each session in the workflow. it performs the following tasks:
• Reads session information from the repository.
• Expands the server, session, and mapping variables and
parameters.
• Creates the session log file.
• Validates source and target code pages.
• Verifies connection object permissions.
• Runs pre-session shell commands, stored procedures and SQL.
• Creates and run mapping, reader, writer, and
transformation threads to extract, transform, and load data.
• Runs post-session stored procedures, SQL, and shell commands.
• Sends post-session email.
| Is This Answer Correct ? | 13 Yes | 2 No |
Post New Answer View All Answers
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What are the types of data warehouses?
Explain sessions. Explain how batches are used to combine executions?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
How can you increase the performance in joiner transformation?
Which transformation should we use to normalise the COBOL and relational sources?
Explain lookup transformation source types in informatica
What do mean by local and global repository?
How to go to the older version for a mapping?
How do you change a non-reusable transformation to reusable transformation?
What is a filter transformation and why it is an active one?
What are the differences between a connected lookup and unconnected lookup?
Name the different lookup cache(s)?
Can we create multiple integration service on single repository?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
