HOW TO GET THE LATEST DATA IN SCD ?




Answers were Sorted based on User's Feedback



HOW TO GET THE LATEST DATA IN SCD ?..

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 ?    11 Yes 1 No

HOW TO GET THE LATEST DATA IN SCD ?..

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 ?    10 Yes 0 No

HOW TO GET THE LATEST DATA IN SCD ?..

Answer / mgm

based on time stamp

Is This Answer Correct ?    5 Yes 0 No




HOW TO GET THE LATEST DATA IN SCD ?..

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

Post New Answer



More Informatica Interview Questions

My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail

2 Answers   Amdocs,


Can informatica load heterogeneous targets from heterogeneous sources?

0 Answers  


difference between informatica 8.1.1 and 8.6

0 Answers   TCS,


what is the difference between copy object import objects using repositery manager which one is best

1 Answers   TCS,


What is the need for an etl tool?

0 Answers  






Can we override a native sql query within informatica?

0 Answers  


can anyone explain me about sales project in informatica?

8 Answers   MBT, Satyam,


what is inline view?

1 Answers   IBM,


Briefly explain the aggregator transformation?

0 Answers  


.prm wirh repalce .txt is possible?

2 Answers  


What are the reusable transforamtions?

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?how

4 Answers   CTS,






Categories