Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different types of Type2 dimension maping?
- 1 Answers
- 5719 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?
How can i set break points in debugging mode ? can explain steps please?
Mention few power centre client applications with their basic purpose?
Hi, Steps for upgrading from informatica 7x to 9x or the link which will help me to upgrade from informatica 7 to 9. Regards, Eva
diffrence between command task and control task
LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Using the LookUP Condition How many types of relational conditions we can make ?
What is data movement mode in Informatica and difference between them?
Plz can any one say me how to get the informatica certification materials and dumps
1)what is the use of bottlenecks in informatica. 2)where we are use shellscripting. 3)what meant by informatica.
when we use dynamic lookup,if condition matches what will be the o/p?
what is fact and what types of fact tables is there
Is it possible to create multiple domains on a single Informatica server?
Teradata 
