Interested to Buy Any Domain ? << Click Here >> for more details...
What are slowly changing dimensions?
- 5 Answers
- 30575 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
Is there any target staging area in informatica not staging area
What do you mean by enterprise data warehousing?
How many number of sessions can one group in batches?
explan ur project architecture?
During the running session, output files are created by informatica server. Enlist few of them.
What differs when we choose the sorted input for aggregator transformation?
How to load data in informatica ?
What is an Integration service in Informatica?
What are the uses of etl tools?
what is informatica metadata?
What is complex mapping?
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
How can we use batches?
without table how to come first record only in oracle?
Explain the informatica workflow?
