Answer Posted / murali
Mr.Chandra,
SCD's are the essential mappings we need to useto maintain
Datawarehouses. Coz,if we are serving our clients with
maintainance, we ought to update their data with necessary
changes. the changes can be,
1. Inserting the data from the latest OLTP database
2. Updating our OLAP DWH with changes.
3. Maintaing the change, as well as Historical data etc...
All these, can be done using SCD's only...
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is informatica etl tool?
What are the features of complex mapping?
Whats the difference between informatica powercenter server, repositoryserver and repository?
Where are the source flat files kept before running the session?
Is it possible to create multiple domains on a single Informatica server?
How we can create indexes after completing the loan process?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is the sql query overwrite in source qualifier in informatica
How can informatica be used for an organization?
What is depict expression change?
What is the function of union transformation?
What is intricate mapping?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What are roles and groups and benefits of using them?