Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7145 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 are the modules in Power Mart?
What is etl process? How many steps etl contains?
Define Dynamic push down optmization?
what happens if the info.server doesn't find the session parameter in the parameter file?
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
what is the meant by Normalization and de-normalization?
architural difference between 7.1 workflow monitor and 8.1 workflow monitor.
How can we handle Rejection Logic in Source tables while we are matching the data in Target side in ETL Testing ?
diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture
explain the methodology of Data Warehousing?(Polaries)
what happens if the info.server doesn't find the session parameter in the parameter file?
Hi can anyone write query for the below input and output Table 1 col 1 100 Null 200 300 Table 2 col1 Null 400 700 800 o/p 200 700 800 2)sql col 1 contains 23x-5-45 26x-12-45 28x-10-50 o/p middlevalue should be greater than 10
Teradata 
