Answer Posted / swetha
Master thread: Creates and manages all other threads
Maping thread: One maping thread will be creates for each
session.Fectchs session and maping information.
Pre and post session threads: This will be created to
perform pre and post session operations.
Reader thread: One thread will be created for each partition
of a source.It reads data from source.
Writer thread: It will be created to load data to the target.
Transformation thread: It will be created to tranform data.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What are the differences between joiner transformation and source qualifier transformation?
What is workflow monitor?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is the status code in stored procedure transformation?
What is the need for an etl tool?
what are factless facts? And in which scenario will you use such kinds of fact tables.
How to go to the older version for a mapping?
What does command task mean?
What is DR strategy for Informatica project?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
How would you copy the content of one repository to another repository?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
How to convert multiple rows to single row (multiple columns) in informatica
What is the difference between Active and Passive transformation?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me