scd methodology?

Answer Posted / vignesh muralidharan

Type1: No historical datas will be available, when changes
are made the old data will be deleted and the new data will
be insrted.

Type2: Flag:The old data will be denoted as false and the
new data will be denoted as true.

Version:The changes made will be numbered as 0,1,2...so on.

Date:The changes along with the date in which they are made
are clearly mentioned.

Type3:The latest change which is made is alone available.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many input parameters can exist in an unconnected lookup?

1156


Which version configuration tool used in ur project?

2867


What is meant by lookup transformation? Explain the types of lookup transformation?

655


What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

1744


What are the different options available for update strategy?

666






Mention few advantages of router transformation over filter transformation.

742


What is complex mapping?

761


wf dont have integration severances how you can run?

1626


According to his methodology what all you need before you build a datawarehouse

1292


Explain pushdown optimization $pushdownconfig parameter - informatica

816


What is repository manager?

634


What is persistent lookup cache?

693


How can we handle two sessions in informatica?

691


explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

1797


How many ways are there to create ports?

819