Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different types of Type2 dimension maping?
- 1 Answers
- 5648 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
What is meant by lookup transformation?
Can we create a node as a gateway node and the same node can be assigned to a grid?
What is persistent lookup cache?
What is a joiner transformation and why it is an active one?
What are the tuning techniques you applied during your last project
What are the advantages of informatica?
Define update strategy?
How can we use batches?
Explain the different kinds of facts.
What is target load order?
What is flashback table ? Advance thanks
What is a predefined event?
What is a stored procedure transformation?
Explain what is informatica metadata and where is it stored?
How many types of sessions are there in informatica.please explain them?
