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
Can we override a native sql query within informatica?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
Define filter transformation?
Explain pmcmd command usage in informatica
What could be the possible resons of locks by user?
What is a shortcut and copy in Informatica and how two are different with each other?
What is a code page?
How to do unit testing in informatica? How to load data in informatica ?
Explain the informatica workflow?
Explain the aggregator transformation?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What are the main features of Oracle 8i with context to datawarehouse?
what is unit testing?tell me proceedure
what is song in infrmatica...?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.