Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

HOW TO GET THE LATEST DATA IN SCD ?

Question Posted / itsranjan

Answers were Sorted based on User's Feedback



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

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 ?    13 Yes 2 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

Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how

1 Answers   IBM,

Explain the etl program with few examples.

0 Answers  

what are the row and column separations in Flat Files

3 Answers   CTS,

Label in Informatica. How to remove existing Label.

1 Answers   IBM, Infosys,

How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks

2 Answers   Puma,

If one flat file contains n number records., we have to load in target from 51 to 100.. how to use expressions in Informatica..?

2 Answers  

Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|FF WW|AA I need to get the length of the column without the ‘|’ .

5 Answers  

Name the different lookup cache(s)?

0 Answers  

What is meant by lookup transformation? Explain the types of lookup transformation?

0 Answers  

Where should yoU place the flat file to import the flat file defintion to the designer?

4 Answers  

how can we calculate fact table size?

1 Answers  

How to generate sequence numbers using expression transformation?

0 Answers   Informatica,

For more Informatica Interview Questions Click Here
Categories