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, 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