Answer Posted / swetha
After the loadmanger performs validations for session,it
creates the DTM process.DTM is to create and manage the
threads that carry out the session tasks.I creates the
master thread.Master thread creates and manges all the other
threads.
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
What are Dimensional table?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What all join we can perform in LOOKUP transformation?
How can one identify whether mapping is correct or not without connecting session?
can we override a native sql query within informatica? Where do we do it? How do we do it?
lookup transformation with screenshots
Define Pmrep command?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What is meant by active and passive transformation?
In informatics server which files are created during the session rums?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?