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 facttable granularity?

2 Answers  

permutations of mapplet

0 Answers   TCS,

What is informatica powercenter repository?

0 Answers  

As a support project team member, how will you get the questions regarding errors from client or customers (in which format)?

1 Answers  

without update strategy how to insert &update?

1 Answers   DELL,

How do you do error handling in Informatica?

1 Answers  

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

3 Answers  

What is complex mapping?

0 Answers  

Mention a few design and development best practices for informatica?

0 Answers  

Could any one to tell Fact table Partitioning?

2 Answers  

how to join two flat files in informatica?

3 Answers   Wipro,

There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department. Write a query

7 Answers   IBM,

For more Informatica Interview Questions Click Here
Categories