Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / purva
Slowly changing dimensions are dimension tables that have
slowly increasing dimension data, as well as updates to
existing dimensions.
Ex : if a person Mr. x is living in the city C1 has a
transaction in a bank and his details is maintained and
after some years he moves to city C4, that means he has his
new details develped but the bank need to maintain the
details i.e both c1 and c2 details ,the history has to be
maintained fully or sometimes partially , so in this cases
the necessity of SCD is required
When updating existing dimensions, you decide whether to
keep all historical dimension data, no historical data, or
just the current and previous versions of dimension data.
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What is aggregator transformation in informatica?
How to create the source and target database connections in server manager?
What is source qualifier transformation in informatica?
Explain the difference between mapping parameter and mapping variable?
What do you mean incremental aggregation?
how tokens will generate?
What is blocking transformation?
explain abt ur project architecture?
What is meant by target load plan?
What is the difference between Active and Passive transformation?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Explain how many types of dimensions are available in informatica?
What is complex mapping?
What is the different lookup cache(s)?
