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 |
Can we run session without using workflows?
What is the use of an aggregator cache file?
wht target override?wht advantages it has compare to target update?
what are the difference between Informatica 7.1 and 8.1?
what is data driven?
if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20000,30000,40000 ex-output eno totsal 1 30000 2 50000 3 70000
What is a sequence generator transformation?
please let me know which type of question arise in interview on project manager round on insurance project with answer pls reply asap.
Differentiate between mapping parameter and mapping variable?
What is sorter transformation?
What are the informatica performance improvement tips
What are Dimensional table?