Answer Posted / 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 |
Post New Answer View All Answers
How do you update the records with or without using update strategy?
explan ur project architecture?
What are the tuning techniques you applied during your last project
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
How do you handle two sessions in Informatica
Define update strategy?
What is substr in informatica?
How to create or import flat file definition in to the warehouse designer?
How can you define user defied event?
What is the difference between STOP and ABORT options in Workflow Monitor?
Enlist the various types of transformations.
What is a repository? And how to add it in an informatica client?
What is a transaction control transformation?
What are the types of caches in lookup? Explain them.
How do you load alternate records into different tables through mapping flow?
