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...

What are the different types of Type2 dimension maping?

Answer Posted / chaitanya

Using SCD2 mapping Target warehouse can store recent data+ complete historical data

Type2 dimension mapping or SCD2 mapping can be implemented in 4 ways: i)Limited number of Histories
ii)Star Schema support implementation
iii)Unlimited number of Histories
iv)Unconnected Stored Procedure

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain informatica architecture - version 8 / 9

1087


Define mapping and session?

1033


Explain lookup transformation is active in informatica

1102


design of staging area?

2030


HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1900


Explain the code page compatibility?

1061


What is Session and Batches?

1106


What are junk dimensions?

1068


waht type of interface is used for testing the data in informatica

2254


which one is better performance wise joiner or look up

1088


Explain load alternative records / rows into multiple targets - informatica

1150


What are roles and groups and benefits of using them?

1055


what is diff b/t sorter t/r and agg have the option sorter property...

2171


Explain scd type 3 through mapping.

999


How can you define user defied event?

1026