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 is dimensional modelling?
Explain normalization?
In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?
What is difference between Mapplet and reusable transformation?
What is the capacity of power cube?
what is the difference between MOLAP and ROLAP?
What is Operational Data Store?
What needs to be done while starting the database?
Can you explain how analysis service works?
Explain difference between e-r modeling and dimentional modeling?
Explain can report net connect multiple datasource at a time in report creation time?
If I have table T1 and table T2 T1 has 250 cols and 10,000 rows T2 has 2 billion rows and 10 cols Which one would be Fact table and which one would be Dimension table and why ?
3 Answers Extech, Principal Finance,