Interested to Buy Any Domain ? << Click Here >> for more details...
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 enterprise data warehousing?
What is target load order?
Explain transaction control transformation in informatica
How can we delete duplicate rows from flat files?
Enterprise data warehouse your projects phase by phase explain?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Which are the different editions of informatica powercenter that are available?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What is session task and command task?
What do think which one is the better joiner or look up?
what is informatica metadata?
How many numbers of sessions can one group in batches?
Explain how many types of dimensions are available in informatica?
Enlist the differences between database and data warehouse.
