list the transformation used for the following:Heterogeneous
sources,Homogeneous sources,Find the 5 highest paid
employees with in a dept,create a summery table,generate
surrogate keys
- 2 Answers
- 6535 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / nagesh
For Heterogeneous sources,use joiner transformation
Homogeneous sources go for source qualifier transformation
TOP 5 SAL
SELECT ROWNUM,ENAME,SAL FROM (SELECT ENAME,SAL FROM EMP
ORDER BY SAL DESC)
Where rownum <6
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / dw_worker
Heterogeneous sources - Joiner
Homogeneous sources - Source Qualifier
Find the 5 highest paid employees with in a dept - Rank
Create a summary table - Aggregator
Generate surrogate keys - Sequence Generator
| Is This Answer Correct ? | 3 Yes | 0 No |
what is a worklet?
Eliminating of duplicate records without using dynamic lookups
What are the steps involved in etl process?
Do we need an etl tool?
can be used COM component in Informatica ?
Can there be sub steps of etl steps?
what are the facilities provided by OLAP to analytical users?
what happens if the info.server doesn't find the session parameter in the parameter file?
you have created a lookup transformation for a certain condition which if true returns multiple rows. when you go to the target and see only one row has come and not all. why is it so and how it can be corrected.
what happens if the info.server doesn't find the session parameter in the parameter file?
Need Informatica Power Center 9.1 free download(for all windows version)
Which transformation we use to convert 'NA' to 'Not Available'
Teradata 
