What are the different types of Type2 dimension maping?
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 |
Enlist few areas or real-time situations where informatica is required.
Explain the aggregator transformation?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
When do you use sql override in a lookup transformation?
Can we get 1st record through Informatica(without sequence number).
List the transformation in informatica.
What is the difference between a router and a filter transformation?
what is normalizer transformation?
How can we use mapping variables in informatica? Where do we use them?
In session log thier should not be a single error how will u do
What is informatica? Why do we need it?
i have two tables,table 1 having 2 columns and 3 rows,table2 having 3 columns and 2 rows.what is the output if i do left outerjoin,full outer join,right outer join?