In a star schema, are foreign key constraints between facts and dimensions neccessary?
What is the difference between mapping parameter & mapping variable in data warehousing?
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.
What is the use of tabular model, tabular sql, tabular reference in real time application?
Explain what are the mapping paramaters and maping variables?
How do you call a module named �testmod.cfm� with the parameters param1=�yes� and param2=5?
Explain what are the steps to build the data warehouse?
Explain what is the difference between powerplay transformer and power play reports?
Explain why fact table is in normal form?
What is dimensional modelling?
Explain the differences between normalizer and normalizer transformation?
What is Discrete and Continuous data in Data mining world?
Explain what is the advantages data mining over traditional approaches?
What is surrogate key? Explain with examples.
Where we use surrogate key explain with example?