Answer Posted / sailaja
using xmlpath function
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
List any five applications of data warehouse.
What is conformed fact?
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.
Explain the difference between data ware house & data mart?
What are target types on the server?
Explain what is the difference between datawarehouse and bi?
What is the main difference between inmon and kimball philosophies of data warehousing?
How can you set the client management?
Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?
What is Analysis Services?
How do you create surrogate key using ab initio?
What is recovering sessions?
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.
Can a dimension table contain numeric values?
What are the steps involved in designing a fact table?