Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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

Answers were Sorted based on User's Feedback



list the transformation used for the following:Heterogeneous sources,Homogeneous sources,Find the 5..

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

list the transformation used for the following:Heterogeneous sources,Homogeneous sources,Find the 5..

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

Post New Answer

More ETL Interview Questions

What are the modules in Power Mart?

0 Answers  


What is etl process? How many steps etl contains?

0 Answers  


Define Dynamic push down optmization?

0 Answers   HP,


what happens if the info.server doesn't find the session parameter in the parameter file?

0 Answers  


What are snapshots? What are materialized views & where do we use them? What is a materialized view log?

0 Answers  


what is the meant by Normalization and de-normalization?

0 Answers  


architural difference between 7.1 workflow monitor and 8.1 workflow monitor.

1 Answers   IBM, Infosys,


How can we handle Rejection Logic in Source tables while we are matching the data in Target side in ETL Testing ?

2 Answers  


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

0 Answers   L&T,


explain the methodology of Data Warehousing?(Polaries)

0 Answers  


what happens if the info.server doesn't find the session parameter in the parameter file?

2 Answers  


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

0 Answers   Cap Gemini,


Categories