how many ways can we implement SCD2?
- 4 Answers
- 14652 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sbvp
1.FLAG
2.versioning
3.date range
there is three types to implement scd2.
| Is This Answer Correct ? | 16 Yes | 1 No |
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 |
Answer / kumar raja kotakonda
1) FULL HISTORY
2) DATE RANGE
3) VERSINING
4) FLAGING
| Is This Answer Correct ? | 2 Yes | 0 No |
wt is inline view? when and why we Use ?mail to rayallarv@gmail.com
CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING? IF SO HOW?
explain about informatica server architecture?
What is Cognos script editor?
 Informatica Checkpoints
whats the option in informatica 7 version is outdated in informatica 8 version onwards.
What is incremental aggregation and how it is done?
8 Answers JPMorgan Chase, TCS,
Is snow flake or star schema used? If star schema means why?
when informatica 8 series released ?
What are the technical challenges faced in Informatica production support member? Give any one example and how to solve it?
Different sorts of metadata that stores in the storage facility?
Can you generate sequence numbers without using the sequence generator transformation?
Teradata 
