Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different types of Type2 dimension maping?
- 2 Answers
- 10453 Views
- CTS, I also Faced
- E-Mail Answers
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
What are the performance considerations when working with aggregator transformation?
what are factless facts? And in which scenario will you use such kinds of fact tables.
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
How to create a non-reusable instance of reusable transformations?
What is rank transformation in informatica
what is degenerated dimension?
As union transformation gives UNION ALL output, how you will get the UNION output?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
COM components can be used in Informatica
What is a stored procedure transformation?
What are the data movement modes in informatica?
Explain sessions and how many types of sessions are there?
