Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.
1431for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?
1658Post New Data Warehouse General Questions
Explain what are the advantages of query studio compared to report studio?
Explain about core dimension, balanced dimension, and dirty dimension?
Database in use is oracle?
Where the data cube technology is used?
Explain what is the difference between datawarehouse and bi?
Explain the difference between data ware house & data mart?
How do you create surrogate key using ab initio?
Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?
What are the various transformation available?
What is the use of tabular model, tabular sql, tabular reference in real time application?
How to define a cube??
Can you state some of the innovations throughout history?
What are data validation strategies for data mart validation after loading process?
Explain what is a view as it relates to system modeling?
How can we do data cleaning?