1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

scd methodology?

Question Posted / nalini pasupulati

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

What did you do in source pre load stored procedure

1 Answers  

WAT IS THE MEANING OF UPGRADTION OF REPOSITORY?

1 Answers   Wipro,

How to eliminate duplicates from flat file..what is the procedure

4 Answers  

can v update d records in target using update stargey without generationg primary key ? explain

4 Answers   CTS,

HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND REMAINING TO OTHER TARGET?

6 Answers  




Explain the pipeline partition with real time example?

0 Answers   Informatica,

Can you please mail me a copy of Informatica Certification Exam dumps to r_balakrishna@yahoo.com

21 Answers  

What is the Difference between sorter and aggregator?

2 Answers  

get me output as if input is like 1 x o/p-->1 x,y,z 1 y 2 a,b 1 z 3 c 2 a 2 b 3 c

0 Answers   Infosys,

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

3 Answers  

What is the difference between unicode & ascii mode data movement in informatica?

1 Answers   TCS,

In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?

1 Answers  

For more Informatica Interview Questions Click Here
Categories