What are two types of processes that informatica runs the
session?
Answer Posted / swetha
Load manager Process: Starts the session, creates the DTM
process, and sends post-session email when the session
completes.
The DTM process. Creates threads to initialize the session,
read, write, and transform data, and handle pre- and
post-session operations.
Is This Answer Correct ? | 16 Yes | 2 No |
Post New Answer View All Answers
What do you mean by filter transformation?
What is difference between a gateway node and worker node?
What is a node in Informatica?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What is flashback table ? Advance thanks
Whats the difference between informatica powercenter server, repositoryserver and repository?
Can you generate sequence numbers without using the sequence generator transformation?
What is a repository manager?
During the running session, output files are created by informatica server. Enlist few of them.
Repository user profiles
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Explain the difference between mapping parameter and mapping variable?
What is a dimensional model?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?