Can you explain how analysis service works?
Answer / azhar
analysis service works by making use of both OLAP and data
mining.
Is This Answer Correct ? | 0 Yes | 1 No |
What is the data type of the surrogate key?
Describe the differences between a data warehouse and data mart.
Explain the definition of normalized and denormalized view and what are the differences between them?
What is XMLA ?
For faster process, what we will do with the universe?
Explain what are the advantages of query studio compared to report studio?
In document how to create metrics?
How can you import tables from a database?
Explain how to get the first 100 rows from the flat file into the target?
Explain what are the mapping paramaters and maping variables?
What are the different ways to represent the loading of dimension tables?
What are the various tools? Explain name a few?