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 many ways can we implement SCD2?

Answer Posted / pune.rohitsharma

my ans is
1)date range
2)key
3)flag
here i have one thing to say
what about with pk key and with out pk will it come into
picture when we are talking about diff ways of implementing
SCD type 2

Is This Answer Correct ?    7 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is data transformation manager process?

1221


How is union transformation utilized?

1060


Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

2082


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

1178


Why union transformation is an active transformation?

1102


Write the program through which the records can be updated?

1053


Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2479


What is a passive transformation?

1152


How many types of sessions are there in informatica.please explain them?

1210


Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1150


What is different between the data warehouse and data mart?

1112


server hot-ws270 is connect to Repository B. What does it mean?

2653


explain one complex mapping with logic? sales project?

6733


What is data movement mode in Informatica and difference between them?

1183


Define mapplet?

1059