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 are snapshots?

0 Answers  


What is etl process. How many steps etl contains explain with example?

0 Answers  


What is tracing level and what are the types?

0 Answers  


where are the log files generally stored.Can you change the path of the file.what can the path be?

0 Answers  


Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?

1 Answers  


where we cannot use sorter Transformation. if we use then we will not get correct data?

0 Answers  


What are the types of data warehouse applications and what is the difference between data mining and data warehousing?

0 Answers  


what is Forward,Reverse and Re_engineering?

0 Answers   QualTech,


Can anyone explain me a scenario from banking and finance...more precisely a mapping

0 Answers   IBM,


what are the reports developed in sap bw project and what is the requirement for developing it?

0 Answers   Maersk,


how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)

0 Answers   Thomson,


how many maximum session supports to multiload in teradata ??

0 Answers   IBM,


Categories