how many ways can we implement SCD2?

Question Posted / pune.rohitsharma

4 Answers
15915 Views
IBM, TCS, I also Faced
E-Mail Answers

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 galaxy repository?

2 Answers

What is a look up function? What is default transformation for the look up function?

2 Answers ASM, TCS,

What is predefined event?

1 Answers

my session have to run Monday to Saturday not run sunday how to sedule in informatica level?

1 Answers Infinite Computer Solutions,

Source Qualifier is an active t/r but there is no change of row count then y should we called it active t/r & Router , sorter some times no change in row count then Y we called its active t/r?

2 Answers

In a sequential batch can u run the session if previous session fails?

3 Answers

What are the challenges of Dataware housing in the future?

2 Answers HP,

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

0 Answers Puma,

What is hash partition?

1 Answers

Write the prerequisite tasks to achieve the session partition?

0 Answers

wtite sql query following table are city gender no chennai male 40 chennai female 35 bangalore male 10 bangalore female 25 mumbai female 15 i want the output? city male female chennai 40 35 bangalore 10 25 mumbai null 15

3 Answers Bank Of America,

I am having source ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI Target ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI If a new record coming from source from same location it should directly go to specified location in target at begining EX:if Eno with 4 coming from same Pune, It should directly load into the Pune location col with '|' symbol. Help me its very urgent

5 Answers Polaris, Zensar,

For more Informatica Interview Questions Click Here