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...


two sources S1,S2 containing measures M1,M2,M3, 4 dimensions
D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and
surrogate keys K1,K2,K3,K4
(a) write a sql statement to populate Fact table F1
(b) Design a mapping in Informatica for loading of fact
table F1.


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More ETL Interview Questions

What is etl tool in hadoop?

0 Answers  


Explain the key challenges that you face while performing etl testing.

0 Answers  


Is apache nifi an etl tool?

0 Answers  


what is session partitioning?

0 Answers  


What is etl process?

0 Answers  


How can we use external procedural logic in informatica?

0 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,


what are the reporting tools and difference between them?

0 Answers  


What is staging area referring to?

0 Answers  


What are the names of the layers in etl?

0 Answers  


What is tracing level and what are the types?

0 Answers  


how do u decide whether u need to do aggregations at database level or at Informatica level?

1 Answers   QualTech,


Categories