Proactive, Retroactive and immediate Update
Explain the following terms: Proactive, Retroactive and immediate Update.
Expert
Proactive Update:
The updates which are applied to database before this becomes effectual within real world.
Retroactive Update:
The updates which are applied to database after this becomes effective within real world.
Immediate Update:
The updates which are applied to database at similar time while this becomes effectual in real world.
What are the drawbacks of the client or server model?
What is meant by the fact table?
What is the main reason that database is considered as "self-describing"?
Describe the term Java bean?
Provide a brief introduction of the term slowly changing dimensions (or SCD)?
Illustrate the difference between the data warehousing and OLAP?
What the difference between sequential file stage and hashed file stage is in relates to DataStage Server?
Assume when a session fails subsequent to loading of 10,000 records in to target. How can we load the records from 10001 the record when we run session next time?
Illustrates the Delete commands.
What is a derived (artificial) primary key? When must this be used?
18,76,764
1937996 Asked
3,689
Active Tutors
1443756
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!