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
What is the difference between STOP and ABORT options in Workflow Monitor?
How to load data in informatica ?
How do you take back up of repository?
Mention some types of transformation?
What you know about transaction control transformation?
What does role playing dimension mean?
How do you update the records with or without using update strategy?
What is the fact table?
What is the session task and command task?
What is target load order?
How to load the data from a flat file into the target where the source flat file name changes daily?
Tell me about Propagate functions in informatica
Differentiate between Load Manager and DTM?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
can anyone suggest best free Talend data integration training online
