What are slowly changing dimensions?
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
Enlist some properties of sessions.
Where do we use mapping variables in informatica?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What are the prerequisite tasks to achieve the session partition?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What is the need of etl tools?
What are the different clients of powercenter?
Explain pushdown optimization $pushdownconfig parameter - informatica
What is the Rank index port in Rank transformation?
Explain about Informatica server process that how it works relates to mapping variables?
What is transformation?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?