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

I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.

3 Answers   Amdocs,


for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.

11 Answers   Accenture,


111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?

3 Answers   IBM,


Examples of Fatal & Non-Fatal error?

1 Answers   Cap Gemini,


what is meant by data driven.. in which scenario we use that..?

2 Answers   IBM,






suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

0 Answers   Patni,


What are the types of presistent cache in look up tr.

0 Answers   IBM,


My questions is i create a two sessions for one mapping.but my requirement is if all number of source records are same as in target then execute first session or some rows are rejected due to t/r logic so session two was execute please clarify

1 Answers   TCS,


What are the different types of Type2 dimension maping?

2 Answers   CTS,


what is bitmap index? did u use it?and how to use it in informatica

1 Answers   IBM,


Is snow flake or star schema used? If star schema means why?

4 Answers   Sonata, CTS,


what is the complex transformation you used in informatica

0 Answers   TCS,






Categories