Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different types of Type2 dimension maping?
- 2 Answers
- 10234 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
server hot-ws270 is connect to Repository B. What does it mean?
What is the sql query overwrite in source qualifier in informatica
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
Explain the difference between mapping parameter and mapping variable?
Why union transformation is an active transformation?
What are mapplets? How is it different from a Reusable Transformation?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What are session parameters ? How do you set them?
What all join we can perform in LOOKUP transformation?
Explain sessions. Explain how batches are used to combine executions?
Why do you use Mapping Parameter and mapping variable?
explan ur project architecture?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What are the limitations of joiner transformation?
