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

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

how many ways can we implement SCD2?

Question Posted / pune.rohitsharma

Answers were Sorted based on User's Feedback



how many ways can we implement SCD2?..

Answer / sbvp

1.FLAG
2.versioning
3.date range
there is three types to implement scd2.

Is This Answer Correct ?    16 Yes 1 No

how many ways can we implement SCD2?..

Answer / 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

how many ways can we implement SCD2?..

Answer / kumar raja kotakonda

1) FULL HISTORY
2) DATE RANGE
3) VERSINING
4) FLAGING

Is This Answer Correct ?    2 Yes 0 No

how many ways can we implement SCD2?..

Answer / radhakrishnansk

write pl sql scripts

Is This Answer Correct ?    2 Yes 10 No

Post New Answer

More Informatica Interview Questions

What is an MDDB? What is the difference between MDDBs and RDBMSs?

3 Answers  

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

0 Answers   IBM,

What are the different options used to configure the sequential batches?

2 Answers   Wipro,

What are the issues that you have faced while moving your project from the Test Environment to the Production Environment?

1 Answers  

replace multiple spaces with single space.

3 Answers   IBM,

daily how much amount of data send to production?

4 Answers   HSBC,

How to generate the HTML output using Informatica.

3 Answers   Wipro,

How to go to the older version for a mapping?

0 Answers  

What is the difference between STOP and ABORT options in Workflow Monitor?

0 Answers  

What are the informatica performance improvement tips

0 Answers   Informatica,

In Datastage, we have row generator stage to generate dummy row. Is there any such transformation in Informatica. Thanks in advance, Kumar

1 Answers  

what is data driven?

5 Answers   TCS, Wipro,

For more Informatica Interview Questions Click Here
Categories