Interested to Buy Any Domain ? << Click Here >> for more details...
What are slowly changing dimensions?
- 5 Answers
- 30824 Views
- Informatica, Verinon Technology Solutions, I also Faced
- E-Mail Answers
Answer Posted / chaitanya
SCD, is a technique used to store the historical value of
dimension attributes.
The values of dimensional attributes change as time goes by.
When these attribute values change, you can overwrite the
old values with the new ones, or you can
preserve the old value.
There are two methods of preserving the old attribute
values: you can store the old values as rows, or you can
store them as columns
three types of SCD:
• SCD type 1 overwrites the old values of the attributes so
the old values are not kept.
Ex: In product dimension,we will use SCD type 1, meaning we
will overwrite the old attribute values.
SCD type 2 keeps the old values by creating a new row for
each change.
SCD type 3 keeps the old values by putting them in another
column
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
How to update a particular record in target with out running whole workflow?
What is a predefined event?
What is difference between a gateway node and worker node?
What do you understand by SOA of Informatica?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What is informatica metadata and where is it stored?
What is the difference between writing a joiner query in ANSI style and THETA style?
Write the advantages of partitioning a session?
How to load a Dimension ? and how to load a fact table?
How can we store previous session logs?
Different circumstance which drives informatica server to expel records?
What is an unconnected transformation?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What are the types of lookup transformation?
