What are the mapings that we use for slowly changing
dimension table?
Answer Posted / surya
slowly changing dimensions can be classified by three types.
1)Type1:In this dimension we can store only current data
and here insert are treated as inserts and updates are
treated as updates.
2)Type2:In this dimension we can store complete historic
data and it can divided into three types
a)Flag
b)Version
c)Date Range
But in type2 inserts are treated as inserts and updates are
treated as inserts.
3)Type3:In this dimension we can store One time historic
data with current data.Here also inserts are treated as
insert and updates are treated as updates.
It's depend upon the granularity of the organization.
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How to partition the Session?
Sequence generator, when you move from develoment to production how will you reset
What is joiner transformation in informatica?
Mention some types of transformation?
Explain the mapping variable usage example in informatica
Is it possible to revert a global repository to local one and why?
What are pre and post-session shell commands?
What is the way to execute pl/sql script using informatica mapping?
How many ways a relational source definition can be updated and what are they?
Clarify the utilization of aggregator cache record?
How to load the data from a flat file into the target where the source flat file name changes daily?
How can we update a record in the target table without using update strategy?
Design a mapping to load the cumulative sum of salaries of employees into target table?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What is the difference between Active and Passive transformation?