how many ways can we implement SCD2?
Answers were Sorted based on User's Feedback
Answer / sbvp
1.FLAG
2.versioning
3.date range
there is three types to implement scd2.
Is This Answer Correct ? | 16 Yes | 1 No |
Answer / pune.rohitsharma
my ans is
1)date range
2)key
3)flag
here i have one thing to say
what about with pk key and with out pk will it come into
picture when we are talking about diff ways of implementing
SCD type 2
Is This Answer Correct ? | 7 Yes | 3 No |
Answer / kumar raja kotakonda
1) FULL HISTORY
2) DATE RANGE
3) VERSINING
4) FLAGING
Is This Answer Correct ? | 2 Yes | 0 No |
while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?
What is an expression transformation?
how to join two flat file if they have diff. structure?how to join one relational and one flat file?
What are the new features of Power Center 5.0?
How the Informatica Server reads perameter file?
1)What is Data Masking in informatica? 2)How to restrict junk characters while loading data into target. 3) what happen if i won't pass sorted input in a transformation.
How to retrieve last two days updated records?
What is a configuration management?
how we do performence tuning in informatica
What is Code Page Compatibility?
How to Explain My project flow,In TCS ased me this question. In which way i can start my project flow and they asked how many fact tables and dimensional tables u used. Can any one Explain Briefly for this question and project architecture also.. please..
3 Answers CTS, HCL, Infosys, TCS,
Hi, source data is col1 values are 5,6,7 col2 are 3,2,1 col3 are 8,9,10 and i want to get target as col1 5,6,7 col2 1,2,3 col3 8,9,10 how to do this one?