scd methodology?

Answers were Sorted based on User's Feedback



scd methodology?..

Answer / rr

SCD means slowly changing dimension.
It represents dimensions that change with time.
There are three types of scds.
Type1: Overwrite (contains no history)
Type2: Add an additional record with time stamp or flag
(contains history)
Type3: Add a new field for the record to represent the new
value(contains history)

Is This Answer Correct ?    1 Yes 0 No

scd methodology?..

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

More Informatica Interview Questions

in mapping i have one source and five targets in that data will be loaded into four targets properily in one target the data is not loaded how will u rectify

3 Answers   Patni,


1) Alternative to update strategy transformation 2) out of 1000 records after loading 200 records, the session got failed. how do u load the rest of records ?? 3) use of lookup override

3 Answers   IBM,


What is a data modeling?

2 Answers  


My source table look like ID Name Location Salary 0000001 ran tpty 1000 0000002 ram DELHI 2000 hju-hji raj hyd 1000 my target table should be ID Name Location Salary 1 ran tpty 1000 2 ram DELHI 2000 hju-hji raj hyd 1000

3 Answers   TCS,


What are the advantages of using informatica as an etl tool over teradata?

0 Answers  






What is source qualifier?

6 Answers   SDS,


Can we use the mapping parameters or variables created in one mapping into another mapping?

1 Answers   Informatica,


How do you load only null records into target? Explain through mapping flow.

0 Answers  


In ur current projectu have done any performance tuning of mappings?

1 Answers  


When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?

5 Answers  


how to import multiple flat files in to single target where there is no common column in the flat files

2 Answers   TCS,


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

0 Answers  


Categories