Interested to Buy Any Domain ? << Click Here >> for more details...
What are slowly changing dimensions?
- 5 Answers
- 30848 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
What is a shortcut and copy in Informatica and how two are different with each other?
Have you worked with/created Parameter file
What is informatica?
What are the prerequisite tasks to achieve the session partition?
What is aggregate cache in aggregator transformation?
What are the types of caches in lookup? Explain them.
Explain the different kinds of facts.
How do you load first and last records into target table?
Explain the difference between a data warehouse and a data mart?
Differentiate between a database and data warehouse?
What are the differences between joiner transformation and source qualifier transformation?
What is data movement mode in Informatica and difference between them?
What is meant by lookup transformation?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Describe expression transformation?
