Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

what is data driven?

5 Answers   TCS, Wipro,

What are the prerequisite tasks to achieve the session partition?

0 Answers  

Can you create a flatfile target

3 Answers   ABC,

i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?

6 Answers   Thomson Reuters,

in flatfile target how can u create header and footer plese give me the comands how will u write in session properties

3 Answers   Patni,

Can we use parameters of parameter file in presession command

1 Answers   Wipro,

What are active transformations? Name them.

1 Answers  

How to extract original records at one target & Duplicate records at one target?

12 Answers  

Explain scd type 3 through mapping.

0 Answers  

Is it possible to use a client with different version than that of its Informatica server?

0 Answers  

What are the different types of Type2 dimension maping?

2 Answers   CTS,

Hi Every One When i Start the Workflow, Table is Going to be Stored in the target database But the columns are not going to the target database table in my PC , please give me the solution and waiting for solution

2 Answers  

For more Informatica Interview Questions Click Here
Categories