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

What is event and what are the tasks related to it?

1102


What is a snowflake schema?

977


What is session task and command task?

1264


Define enterprise data warehousing?

1183


write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2544


How to implement security measures using repository manager?

1152


How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1109


What are Dimensional table?

1046


can u give example for factless fact table

6598


What is informatica powercenter repository?

1171


How to elaborate tracing level?

1155


Explain pmcmd command usage in informatica

1108


Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1097


Differentiate between joiner and lookup transformation?

1094


Why union transformation is an active transformation?

1034