Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different types of Type2 dimension maping?
- 1 Answers
- 5642 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What is the difference between a router and a filter transformation?
How to calculate the cache size if say we are doing a performance check on a mapping and found that a particular cache needs to be changed. Is there a formula to calculate this! i know that informatica has a auto option available but how to calculate manually?
What are the different types of schemas?
what is persistant cache in which situation we will use persistantcache
What is the Router transformation?
how to insert header after each group.
What is the diff. b/w informatica versions 8.1.1 and 8.6.1?
is it possible to index the data in cache of lkp transformation ?
how do u fnd the duplicate rows and how to delete the duplicate rows?
Write the different tools in the workflow manager?
What is the actual work done in Development and in the production depts in building a datawarehouse. Which dept is more interesting and career oriented .
What is the difference between a shortcut of an object and copy of an object? Compare them.
Teradata 
