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
Difference between Target-based loading and constraint-based loading?
Please let me know how to make Data masking in informatica..
what is INFORMATICA TESTING process
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What are data-driven sessions?
What is meant by a domain?
What is data movement mode in Informatica and difference between them?
How to do unit testing in informatica?
How can we improve session performance in aggregator transformation?
What are active transformations.
what is unit testing?tell me proceedure
Briefly define a session task?
Why sorter is an active transformation?
Explain what are the different types of transformation available in informatica.
Could you explain what is enterprise data warehouse?