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

What is a sorter transformation?

747


How can we update a record in the target table without using update strategy?

725


Explain constraint based loading in informatica

722


Mention few power centre client applications with their basic purpose?

594


Define filter transformation?

686






I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1167


waht type of interface is used for testing the data in informatica

1897


What is the function of look up transformation?

724


What are the different options available for update strategy?

633


What are the different types of transformation available in informatica.

698


What is a standalone command task?

742


Can you use flat files in Mapplets.

2288


Difference between Data and Index Caches?

732


How many transformations can be used in mapplets.

1527


SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

1744