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
How might you approve all mappings in the archive all the while?
How to create a non-reusable instance of reusable transformations?
How do you load only null records into target? Explain through mapping flow.
What are the designer tools for creating transformations?
what is degenerated dimension?
what is SDLC way of code development?
what is the difference between informatica6.1 and infomatica7.1
How do you load alternate records into different tables through mapping flow?
What is the format of informatica objects in a repository?
What is a router transformation?
Differentiate between source qualifier and filter transformation?
How you know when to use a static cache and dynamic cache in lookup transformation?
Define sessions in informatica etl?
What do you mean incremental aggregation?
What does reusable transformation mean?
