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
- 6096 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 |
Two default user groups created in the repository are____and_____.
State the differences between shortcut and reusable transformation
What is full load & incremental or refresh load?
How can we handle Rejection Logic in Source tables while we are matching the data in Target side in ETL Testing ?
what is pmrep command?
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
what are the reporting tools and difference between them?
Can u access a repository created in previous version of Informatica?
what is the difference between date cache and lindex cache?
how do use session mapping parameters ?(in which transformation)
What is grain of fact?
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
Teradata 
