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...

HOW TO GET THE LATEST DATA IN SCD ?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

6580


Define filter transformation?

1145


What are the advantages of using informatica as an etl tool over teradata?

1073


differences between service based and product based?

2058


While migrating the data from one environment to another environment how would you manage the connections?

1128


What does “tail –f” command do and what is its use as an Informatica admin.

1144


list out all the transformations which use cache?

1239


How to generate sequence numbers?

1129


What are the components of workflow manager?

1151


what is INFORMATICA TESTING process

2331


Differences between version 7.x and 8.x.

1939


Explain load alternative records / rows into multiple targets - informatica

1202


Differentiate between a database and data warehouse?

1188


Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

2051


Define sessions in informatica etl?

1101