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
Explain informatica architecture - version 8 / 9
Define mapping and session?
Explain lookup transformation is active in informatica
design of staging area?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Explain the code page compatibility?
What is Session and Batches?
What are junk dimensions?
waht type of interface is used for testing the data in informatica
which one is better performance wise joiner or look up
Explain load alternative records / rows into multiple targets - informatica
What are roles and groups and benefits of using them?
what is diff b/t sorter t/r and agg have the option sorter property...
Explain scd type 3 through mapping.
How can you define user defied event?