If your client approaches you and says that he wants to
create a Datawarehouse, and provides just the info
regarding his source systems.
What are all the neccessary actions one is supposed to
take/understand and get back with a comprehensive document
which convinces the client to proceed with the DW
initiative.
What are all the documents we need to provide the client?
Answer / -chaitanya
-First we need to discuss our company standards with the
client though the client is already aware of the standards,
-Need to collect critical to quality points from the
customer.and discus inscoper and outscope of the project.
-Design a datamodel and check with users by setting
iterative meetings till the business and the lead are on
same page.
| Is This Answer Correct ? | 3 Yes | 7 No |
What are the types of dimensional modeling?
What are the vaious etl tools in the market?
What are different stages of ?Data mining??
Explain what is the difference between view filter and report filter?
How can you clear the cache?
Explain what is full load & incremental or refresh load?
What is meant by metadata in context of a data warehouse?
What needs to be done while starting the database?
what is the difference between MOLAP and ROLAP?
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 BCP?
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?