Interested to Buy Any Domain ? << Click Here >> for more details...
What are slowly changing dimensions?
- 5 Answers
- 31046 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 are the databases that informatica can connect to windows?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Can you generate sequence numbers without using the sequence generator transformation?
what are the Methods For Creating Reusable Transformations?
Explain in detail about scd type 1 through mapping.
What is decode in static cache?
Differentiate between a repository server and a powerhouse?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What is a pre-defined event and user-defined event?
What is the sequence generator transformation in informatica?
what is the hint? how to use it to reduce the query processing in program?
What is the maplet?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
