What are slowly changing dimensions?
Answer Posted / ande
there are three types SCD:
type-1: in this we can over write original recourd with new
record
type-2: we can create new record
type-3: we can create new attribute
regards,
ande
Is This Answer Correct ? | 9 Yes | 23 No |
Post New Answer View All Answers
How big was your fact table
Can we get 1st record through Informatica(without sequence number).
Can you generate sequence numbers without using the sequence generator transformation?
What is pmcmd command?
What is the benefit of partitioning a session?
What is powercenter on grid?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
How can we remove the duplicates from flat file source?
What is update strategy transform?
Explain Dataware house architecture .how data flow from intial to end?
How to handle decimal places while importing a flatfile into informatica?
What if the source is a flat-file?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What are the main features of Oracle 8i with context to datawarehouse?
Can we create multiple integration service on single repository?