Introduction of the term active data warehousing
Give a brief introduction of the term active data warehousing?
Expert
An Active data warehouse objects to capture data constantly and deliver real time data. They offer a single incorporated view of a customer across various business lines. It is connected with Business Intelligence Systems.
What is meant by star schema?
What is meant by the User Objects? Specify some of its restrictions?
Justify whether all the Business Objects users build the data providers?
Illustrates the quickest sorting method to use?
What is meant by the Surrogate key?
Explain the four kinds of indexes?
Explain the term Coalesce. Answer: Coalesce is also obtainable in Sybase, this function estimates the listed expressions and returns the first non-null value.
Explain how one source columns or the rows may be loaded within the two different tables?
Provide a brief introduction of the term ‘Data Mart’?
Explain the uses of stored procedure?
18,76,764
1927529 Asked
3,689
Active Tutors
1415453
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!