SCD2 will work on only dimension tables as well as fact Table?


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

Post New Answer

More ETL Interview Questions

How to load Session Statistics (Workflow name, TgtRows, Rejected Rows, SessStartTime,SessEndTime..)into a database table ?? Another Question: I want to pass values from oracle table or Flat file in Mapping parameter/Variable.. What is the method for that..Please provide me the solution step by step

1 Answers  


can cubes contain measures ?

0 Answers  


What are cubes and olap cubes?

0 Answers  


what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?

0 Answers   Accenture,


What are materialized views & where do we use them?

0 Answers  






Where can i get informatica certification Exam dumps and details? please forward it to emailid: krisboppana@yahoo.com

320 Answers   Accenture, College School Exams Tests, CTS, Flextronics, HCL, Infosys, NexGen, Patni, SO, Wipro,


What do you understand by the term ‘transformation’?

0 Answers  


What is tracing level and what are the types?

0 Answers  


where is the cache (lookup, index) created and how can you see it.

0 Answers  


What is a staging area? What is the purpose of a staging area?

0 Answers  


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.

0 Answers  


Need Informatica Power Center 9.1 free download(for all windows version)

1 Answers   ABC,


Categories