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
- 6119 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 different between sequential batch and concurrent batch and which is recommended and why?
Explain the difference between etl tool and olap tools?
What is data cleaning?
can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge
what do u do when DB time takes more?in sap bi
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
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 is partitioning? Explain about round-robin, hash partitioning.
what is data modeling?
where is the cache (lookup, index) created and how can you see it.
Explain about hash partitioning?
what is the meant by Normalization and de-normalization?
Teradata 
