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

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1260


Explain the mapping variable usage example in informatica

1132


Which transformation is needed while using the Cobol sources as source definitions?

1154


Briefly define reusable transformation?

1113


what is the difference between informatica6.1 and infomatica7.1

2250


What are pre and post-session shell commands?

1283


Different qualification between a related rotate toward the sky and isolates look upward?

972


How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

1094


How might one distinguish in the case of mapping is right or not without associating session?

1079


how many types of dimensions are available in informatica?

1066


What is the function of look up transformation?

1105


I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1885


State the limitations where we cannot use joiner in the mapping pipeline?

1042


What is the reusable transformation?

1031


How to create or import flat file definition in to the warehouse designer?

1055