What are two types of processes that informatica runs the
session?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / rekha
LOAD MANAGER : LOAD MANAGER IS THE FIRST COMPONENT NEEDS TO
BE INITIALIZES WHEN THE SESSION IS SUBMITTED TO THE SERVER
LOAD MANAGER MANAGES THE LOAD ON THE INFORMATICA SERVER BY
MAINTAINING A QUEUE OF SESSIONS AND RELEASES THE SESSIONS
BASED ON FIRST COME FIRST SERVE
ONCE THE LOAD MANAGER RELEASES THE SESSION IT
INTIALIZES THE DTM PROCESS
DTM FOLLOWS THE INSTRUCTIONS CODED IN THE SESSION
MAPPING ,FOR EACH SESSION DTM CRAETES READER ,WRITER AND
SHARED MEMORY
| Is This Answer Correct ? | 4 Yes | 0 No |
why we use source qualifier transformation?
what are cost based and rule based approaches and what is the difference?
How will you convert rows into columns or columns into rows
In which conditions we can not use joiner transformation (Limitaions of joiner transformation) ?
In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?
What is enterprise data warehousing?
I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records
what happens if you try to create a shortcut to a non- shared folder?
How to Migrate the UNIX SCRIPTS from SIT TO PROD?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
How does a rank transform differ from aggregator transform functions max and min?
Mapplets can you use an active transformation in a mapplet,