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
How many ways a relational source definition can be updated and what are they?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What is a connected transformation?
can we override a native sql query within informatica? Where do we do it? How do we do it?
How do you load first and last records into target table?
What is a sorter transformation?
How to update or delete the rows in a target, which do not have key fields?
Write the program through which the records can be updated?
In development project what is the process to follow for an etl developer from day1
What is workflow? What are the components of workflow manager?
How to join three sources using joiner? Explain though mapping flow.
What is a grid in Informatica?
How can we use mapping variables in informatica? Where do we use them?
Explain lookup transformation source types in informatica
What are connected or unconnected transformations?