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
- 6142 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
where we cannot use sorter Transformation. if we use then we will not get correct data?
explain the methodology of Data Warehousing?(Polaries)
what are the concerns of OLTP and DSS systems?
When do we analyze the tables? How do we do it?
What do you understand by active and passive transformations?
What is partitioning? Explain different types of partitioning?
1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?
What are the various tools used in etl?
What are the types of Data Warehouse applications?
What are the etl testing operations includes?
What are the names of the layers in etl?
What are cubes and olap cubes?
What is fact? What are the types of facts?
What is partitioning? Explain about round-robin, hash partitioning.
what is data modeling?
