Answer Posted / sumeet lalvani
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 ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to join three sources using joiner? Explain though mapping flow.
In informatica workflow manager, how many repositories can be created?
What are the limitations of joiner transformation?
Explain Dataware house architecture .how data flow from intial to end?
draw informatica architecture 8.6 ?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
How can you differentiate between powercenter and power map?
What is event and what are the tasks related to it?
What are the new features of informatica 9.x at the developer level?
Under what condition selecting sorted input in aggregator may fail the session?
How to load the data from a flat file into the target where the source flat file name changes daily?
Explain sessions?
What are the popular informatica products?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
what is degenerated dimension?