how many ways can we implement SCD2?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to generate or load values in to the target table based on a column value using informatica etl tool.

678


Can we create a Integration service without a Repository service and vice versa?

808


What is a passive transformation?

698


what is the size ur source like(file system or database)? how many record daily come u r banking project?

1806


How we can create indexes after completing the load process?

758






Explain why we use partitioning the session in informatica?

663


What is enterprise data warehousing?

678


Explain Dataware house architecture .how data flow from intial to end?

2191


Explain the scenario which compels informatica server to reject files?

726


How many ways are there to create ports?

792


hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1592


Performance tuning( what you did in performance tuning)

1563


What is a difference between complete, stop and abort?

720


Reusable transformation and shortcut differences

1440


What happens to map if we alter the datatypes between source and its corresponding source qualifier?

673