Slowly changing dimensions, types and where will you use them


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

Post New Answer

More Informatica Interview Questions

i have one source 52 million records i want target only 7 records ?how wil you do what logic to implement?

7 Answers   L&T,


in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

0 Answers  


What is joiner transformation in informatica?

0 Answers  


How to prepared lld.can any one tell me detailed explanetion.

0 Answers   Bank Of America,


what are factless facts? And in which scenario will you use such kinds of fact tables.

0 Answers  






How we will implement Pushdown Optimization and Types in Informatica with better examples

4 Answers   TCS,


what are cost based and rule based approaches and what is the difference?

1 Answers  


suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping using aggregator & router? how

7 Answers   TCS,


i have one table like cust_id ph1 ph2 ph3 1002 9290123526 97671927210 9876545232 we use Normalizer wt is o/p? sue normalizer we can generate three tables in single table/

4 Answers  


Is it possible to have "5 source & 5 Target" in single mapping?

1 Answers  


What is a candidate key?

7 Answers   CTS,


How do you convert single row from source into three rows into target?

0 Answers  


Categories