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

how can we load 365 flat file to a single fact table (target) as a history load in single mapping?

2 Answers  

3. Suppose Seq Gen is supplying a increamental value to a column of a table, suppose, table's column value reaches to maximum value, then what will happen, will the session fail? If it is the situation, then what should be done so that we can stop this kind of situation in advance?

7 Answers   Accenture,

How can we improve session performance in aggregator transformation?

0 Answers   Informatica,

update strategy transformation in informatica

0 Answers   Informatica,

How to generate a single mapping for both the historical and incremental load.

2 Answers   CSC, TATA,

What is the difference between warehouse key and surrogate key?

1 Answers   Accenture,

where to select code page option?

2 Answers   TCS,

my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer

5 Answers   IBM, TCS,

Informatica settings are available in which file?

0 Answers   Informatica,

Separate from an archive server and a powerhouse?

0 Answers  

how can we run workflow with pmcmd?

3 Answers   Wipro,

What is a data modeling?

2 Answers  

For more Informatica Interview Questions Click Here
Categories