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 are parameters defined in informatica?
What is a diff between joiner and lookup transformation
16 Answers CTS, Satyam, TCS, UHG,
Hey I am net to informatica? Can any one explain me step by step How scd will work ?
if we have certain records,if i need to get 5 th rec for the first time to the target,when i run it for next time,i need to get 6th rec...like that it should process.what wil be the procedure to achieve it??
scenario
What is the use of an aggregator cache file?
Can we use unconnected lookup as dynamic lookup?
5 Answers ITC Infotech, TCS, Wipro,
Clarify the aggregator change?
What is surrogate key?
What are mapplets? How is it different from a Reusable Transformation?
How Union Transformation is an Active Trans?
IF Sorce table contains CLOB as its one data type then i get error at the target table. How can this be resolve?