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
Whats the difference between informatica powercenter server, repositoryserver and repository?
Explain lookup transformation source types in informatica
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
differences between service based and product based?
What are Dimensional table?
What is resilience time?
Briefly define a session task?
How can one identify whether mapping is correct or not without connecting session?
Enlist some properties of sessions.
Explain what are the different versions of informatica?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
where to store informatica rejected data? How to extract the informatica rejected data?
Is stop and abort are same in informatica?
What is rank transformation?
Design time, run time. If you don't create parameter what will happen