What Oracle tools can be used to design and build a W/H?
What are components of reportnet?
What is operational data store (ods)?
Explain what is the extension of file to save template?
What is a Data Warehouse?
What is the difference between snowflake and star schema?
How many ways we test the universe & Report?
what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.
How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.
Which one among Star and snowflake schemas will occupy more space?
What is Discrete and Continuous data in Data mining world?
What is the metadata extension?
Can you pass sql queries in filter transformation?