Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different types of Type2 dimension maping?
- 1 Answers
- 5715 Views
- I also Faced
- E-Mail Answers
Answer Posted / swetha
source will gets inserted in target along with a new
version number. And newly added dimension in source will
inserted into target with a primary key.
Type2 Dimension/Flag current Maping: This maping is also
used for slowly changing dimensions.In addition it creates a
flag value for changed or new dimension.
Flag indiactes the dimension is new or newlyupdated.Recent
dimensions will gets saved with cuurent flag value 1. And
updated dimensions r saved with the value 0.
Type2 Dimension/Effective Date Range Maping: This is also
one flavour of Type2 maping used for slowly changing
dimensions. This maping also inserts both new and changed
dimensions in to the target. And changes r tracked by the
effective date range for each version of each dimension.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Differentiate between a repository server and a powerhouse?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
COM components can be used in Informatica
What do think which one is the better joiner or look up?
what is mean by complex business rule ?
What is rank transformation in informatica
What are the components of Informatica? And what is the purpose of each?
What is workflow? What are the components of workflow manager?
without table how to come first record only in oracle?
How to implement security measures using repository manager?
Why filter transformation is an active one?
What is the meaning of decode in informatica?
What is an expression transformation?
Describe expression transformation?
