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 Discrete and Continuous data in Data mining world?
How to drill through from a powerplay cube to reportnet?
What is a Data Cube?
What is an OLAP (On-line Analytical processing) system?
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?
What are Fact tables and Dimension Tables?
Explain what are the various methods of getting incremental records or delta records from the source systems?
Explain what is the difference between power center & power mart?
Explain piconet?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?
what is a hot file, why we need in datawarehousing, where we used in general
What is your spectra photometer working principles?