how many ways can we implement SCD2?

Question Posted / pune.rohitsharma

4 Answers
15806 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 joiner change?

0 Answers

How to Create a folder using pmrep command?

0 Answers

What is 'PowerCenter Pushdown Optimization Option' in INFORMATICA ?

5 Answers

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 an MDDB? What is the difference between MDDBs and RDBMSs?

3 Answers

How do you create single lookup transformation using multiple tables?

6 Answers TCS,

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

0 Answers Bosch,

What are teh different tasks that can be created in workflow manager?

1 Answers NIIT,

Hi, What is exactly node ? what is exactly domain ? How loadbalancer will work ? what is Integration service (IS) ? Can anyone give me exact scenario when I click on start workflow in the workflow manager ? (Note : I am not expecting answer like, node means logical representation of a machine and domain will contain multiple nodes .I gone through Informatica help but I couldn’t understand. I am expecting exactly what is happening in background detailed explanation or Pictorial representation will be highly appreciation ) Advance thanks

3 Answers IBM,

What is an expression transformation in informatica?

0 Answers

how much memory (size) occupied by a session at runtime

4 Answers Wipro,

what is the process of target load planing?

2 Answers IBM,

For more Informatica Interview Questions Click Here