Describe the ETL procedure in data warehousing
Briefly describe the ETL procedure in data warehousing?
Expert
ETL sets for Extraction, loading and transformation. That indicates extracting data from various sources like databases, flat files or XML data, transforming this data depending on the application’s loads and need this data in data warehouse.
What do you understand by the termed dependency graph in DBMS?
Why use references quite than pointers within the public API, mainly for arguments that are modified?
How are metadata keys and surrogate handled in MySQL?
Specify the designer tools used for creating the tranformations?
Explain about the stored-procedures and its advantages.
Define the term Cognos 8 BI?
Specify some of the areas where the data warehouses are utilized in the present and in the future?
Briefly describe the new features of SQL Server 2005 Analysis Services (or SSAS)?
States the term SnowFlake.
Write about the term Data stage architecture?
18,76,764
1953553 Asked
3,689
Active Tutors
1454537
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!