HOW TO GET THE LATEST DATA IN SCD ?
Answers were Sorted based on User's Feedback
Answer / bidhar
In SCD 2 you must be generating the surrogate keys.
Example:
Customername Address Customer_id Customer_identifier
Amit Bangalore 100 10
Amit Hyderabad 100 11
Amit Pune 100 12
Amit Mumbai 100 13
Here column Customer_identifier is the surrogate key.
so for latest record ,you can pick up the record which have
maximum surrogate key value(13).
Let me know if i am wrong.
Is This Answer Correct ? | 12 Yes | 0 No |
Answer / raj
IN THREE WAYS WE CAN GET THE LATEST RECORD IN SCD ...
1)IN "SCD TYPE 2 TIME STAMP" FOR LATEST RECORD THE "END
DATE" FIELD WILL BE BLANK. THAT MEANS IT IS THE NEW ROW .
2)IN "SCD TYPE 2 FLAG " THE FLAG NUMBER OF THE NEW ROW WILL
BE ONE .
3) IN " SCD TYPE 2 VERSION " THE LATEST RECORD IS HAVING
THE MAXIMUM VERSION NUMBER .
Is This Answer Correct ? | 13 Yes | 2 No |
Answer / vikneswaran
in type 1 ... only the latest date... so it is very easy to get
in type 2.. to get by using date or flag or version
in type 3.. to get by selecting previous_column
Is This Answer Correct ? | 4 Yes | 0 No |
What is router transformation
What is the difference between procedure and stored procedur?
write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500
How to import oracle sequence into Informatica?
Mapplets can you use an active transformation in a mapplet,
What do you mean incremental aggregation?
What are the databases that informatica can connect to windows?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
how to get flatfile containg 10 records half records one target another half another target
Why we require dwh in particular projects?
Tell me about MD5 functions in informatica
what is the monster dimension plz give me one example