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
- 7332 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
What are the types of Data Warehouse applications?
what is the difference between cubes and package in cognos
Do we need an ETL tool? When do we go for the tools in the market?
What is initial load and what is full load?
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?
How etl testing is different from database testing?
if i have a query as flat file how can we load data to target table
What do you understand by the term ‘transformation’?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
what are the concerns of OLTP and DSS systems?
What are the etl testing operations includes?
What is a staging area? What is the purpose of a staging area?
what are Lookup caches options? Including persistent caches.
When do we analyze the tables?
What are the different etl testing categories as per their function?
