1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

What are the different types of Type2 dimension maping?

Question Posted / swetha


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

Post New Answer

More Informatica Interview Questions

update strategy transformation in informatica

0 Answers   Informatica,

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

0 Answers  

Diff b/w ShortCut and reusabel Object ?

4 Answers  

SRC1 -> EXP -> AGGR -> TGT SRC2 -> EXP -> Above is a maaping with two pipeline connected to the taret TGT. Design wise is this design is correct or not ?

6 Answers   IBM,

What is DTM process?

4 Answers  




How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????

2 Answers   TCS,

How will you update the first four rows and insert next four rows in a mapping?

5 Answers   CTS,

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

0 Answers   Infotech,

list out all the transformations which use cache?

0 Answers   Informatica,

how do u tune queries?

1 Answers  

followin source like region sales 1 100 2 200 i want the output following format region 1 2 sales 100 200

2 Answers   Oracle,

Why update strategy and union transformations are active?

0 Answers  

For more Informatica Interview Questions Click Here
Categories