Fundamental stages of Data Warehousing
Briefly describe the fundamental stages of Data Warehousing?
Expert
Offline Operational Databases: This is the preliminary stage of data warehousing. In this stage the expansion of database of an operational system to an off-line server is finished through basically copying the databases. Offline Data warehouse: In this phase the data warehouses are updated on a standard time cycle from operational system and the data is kept at it in a reporting-oriented data structure. Real time Data Warehouse: Data warehouses are updated depended on event or transaction basis in this stage. An operational system carries out a transaction each and every time.
Integrated Data Warehouse: The transactions or activity generation which is transferred into the operational system is done in this stage. Such generated transactions or transactions are employed in the everyday activity of the organization.
Briefly describe the ETL procedure in data warehousing?
Which member function places a new node on the end of the linked list? Answer: appendNode(): This member function places a new node on the end of t
Illustrates the term Open Server in Sybase?
Explain the object qualification?
Explain the stage variables?
Briefly describe the reason of synchronization function offered in Analysis Services 2005 ?
Explain how in a relation a supertype or subtype is mapped?
What the difference between sequential file stage and hashed file stage is in relates to DataStage Server?
Explain in brief the term apex cuboids.
Specify the various types of Aggregation?
18,76,764
1941493 Asked
3,689
Active Tutors
1436435
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!