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
Why do we need informatica?
How can we remove the duplicates from flat file source?
How do you handle two sessions in Informatica
Write the unconnected lookup syntax?
What is meant by pre and post session shell command?
What is a standalone command task?
What is a sorter transformation?
What is the use of target designer?
How many types of sessions are there in informatica.please explain them?
How big was your fact table
How to generate sequence numbers?
What are the types of lookup transformation?
What are the types of data warehouses?
Explain the code page compatibility?
What are the tasks that source qualifier perform?
