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 complex mapping?
What is joiner transformation in informatica?
What is option by which we can run all the sessions in a batch simultaneously?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
Enterprise data warehouse your projects phase by phase explain?
What is a standalone command task?
What are the different clients of powercenter?
tell me 5 session failure in real time how can you solve that in your project?
Explain about cumulative Sum or moving sum?
What does reusable transformation mean?
What do mean by local and global repository?
Name the different lookup cache(s)?
Explain the types of lookup transformation?
hi real timers . iam waiting for ur reply regarding ETL TESTING
What are the mapping parameters and mapping variables?