Answer Posted / ramjanaki
Confirmed Dimension is, which can be reusable across
multiple data marts.
| Is This Answer Correct ? | 3 Yes | 8 No |
Post New Answer View All Answers
What are the types of dimensional modeling?
Explain some of modeling tools available in the market?
What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?
What is surrogate key? Explain with examples.
Can we take backup when the database is opened?
For faster process, what we will do with the universe?
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.
Describe the differences between a data warehouse and data mart.
What is called dimensional modelling?
What is a hash cluster?
Explain about core dimension, balanced dimension, and dirty dimension?
Explain what is a view as it relates to system modeling?
How can we run the graph? How can we schedule the graph in unix?
How to eliminate duplicate rows from flat file?
What are the different methods of loading dimension tables?
