Answer Posted / gvk
After the loadmanger performs validations for session,it
creates the DTM process.DTM is to create and manage the
threads that carry out the session tasks.I creates the
master thread.Master thread creates and manges all the other
threads.\
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.
RAja u are wrong
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Which transformation is needed while using the Cobol sources as source definitions?
What is the advantage of informatica?
Mention some types of transformation?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What are multi-group transformations?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What is sorter transformation?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Describe expression transformation?
How can we use mapping variables in informatica? Where do we use them?
What is fact table? Explain the different kinds of facts.
What does refresh system mean, and what are its distinctive choice?
Do you find any difficulty while working with flat files as source and target?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What does role playing dimension mean?