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
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is domain and gateway node?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
How do you set a varible in incremental aggregation
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What is transformation?
draw informatica architecture 8.6 ?
Can we create two repositories on same database instance in oracle?
What are the main issues while working with flat files as source and as targets ?
How do you take back up of repository?
What is data caches/ index caches?
What is union transformation in informatica?
Is stop and abort are same in informatica?
Whats the difference between informatica powercenter server, repositoryserver and repository?
