List the transformation used for the following:
(1) Heterogeneous Sources
(2) Homogeneous Sources
(3) Find the 5 highest paid employees within a dept.
(4) Create a Summary table
(5) Generate surrogate keys
Answer / nagapuri
1)Joiner Transformation
2)Source Qualifier and Joiner transformation
3)Rank Transformation.
4)Aggregator Transformation
5)Sequence Generator Transformation
Is This Answer Correct ? | 6 Yes | 0 No |
how to run 2 workflows sequentially. plz respond what is the process?
what is metadata?
Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.
If I have set the property Treat Source Rows as Insert and for the target properties I have checked the boxes Update as Update, what will happen to incoming rows? What exactly is the use of these check boxes and in which scenarios we use them. Also what is the sequence in which informatica understands these properties.Does it takes whatever is defined in treat source rows as property or it is in any other way. Please explain.
What are the reusable transforamtions?
Source is a flat file and want to load unique and duplicate records separately into two separate targets; right??
What are the two modes of datamovement in informatica sever?
What are the tasks that source qualifier perform?
What are the steps involved in the migration from older version to newer version of Informatica Server?
If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?
What is the scenario which compels informatica server to reject files?
what is session parameters?