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
what is the complex transformation you used in informatica
What do you mean by blocking transformation?
Explain the different lookup methods used in informatica?
Can anyone tell me the new features in Informatica 9 Version?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
Can we create a Integration service without a Repository service and vice versa?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What is a router transformation?
How can we update a record in the target table without using update strategy?
What is the commit type if you have a transaction control transformation in the mapping?
Reusable transformation and shortcut differences
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
How to extract sap data using informatica? What is abap? What are idocs?
In informatics server which files are created during the session rums?
wat are deployement groups in informatica, how it will be used for developers