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

scd methodology?

Answer Posted / vignesh muralidharan

Type1: No historical datas will be available, when changes
are made the old data will be deleted and the new data will
be insrted.

Type2: Flag:The old data will be denoted as false and the
new data will be denoted as true.

Version:The changes made will be numbered as 0,1,2...so on.

Date:The changes along with the date in which they are made
are clearly mentioned.

Type3:The latest change which is made is alone available.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7371


How many transformations can be used in mapplets.

1893


What is the use of code page?

1043


How to generate or load values in to the target table based on a column value using informatica etl tool.

1040


I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1593


How we can use union transformation?

1017


4 yrs etl devloper roles and responsibilities?any body give solutions

2108


what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1934


What is the difference between a connected look up and unconnected lookup?

937


Differentiate between a database and data warehouse?

1109


without table how to come first record only in oracle?

2222


What is the Rank index port in Rank transformation?

1030


what is the size of your data warehousing?

2066


How can we delete duplicate rows from flat files?

1186


Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

2041