Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different types of Type2 dimension maping?
- 2 Answers
- 10388 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sumankumar
type2 scd it wil maintain historical informtion + currnt
information along with 3 options .....
1.effective date
2.version number
3.flag value
| Is This Answer Correct ? | 14 Yes | 0 No |
Answer / 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 |
what are objects in data warehouse?
what is constraint based load order
which transformation should we use to get the 5th rank member from a table in informatica?can we achieve this in sql?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
what is the Default Source Option For Update Strategy Transformation?
What do you understand by term role-playing dimension?
what are presession,postsession success and postsession failure commands ?
How do you update the records with or without using update strategy?
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 ??????????
what is lookup ?
What are the methods for creating reusable transforamtions?
Why union transformation is an active transformation?
Teradata 
