Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different types of Type2 dimension maping?
- 1 Answers
- 5574 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 |
when we go for unconnected lookup transformation? and why?
Can we create a node as a gateway node and the same node can be assigned to a grid?
My i/p is 1,2,3,4,5,6,7,8,9,10……….. o/p to be populate in two tables as below. o/p1: 10,20,30,40,50,60,70,80,90……. o/p2: 11,21,31,41,51,61,71,881,91…….
Why we need XMLs?
 Informatica Checkpoints
how can u load the data in time dimension?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
what is the size of your data warehousing?
Explain the mapping variable usage example in informatica
Explain where to store informatica rejected data? How to extract the informatica rejected data?
In which scenario did you used pushdown optimization?
How can we use batches?
Teradata 
