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 Posted / -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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are non-additive facts in detail?

524


How can we run the graph?

573


Tell me what is degree of a relation?

516


Explain Association algorithm in Data mining?

1856


What is aggregate fact table?

525






What is the difference between olap and oltp?

552


what is an use case?

612


What is data warehouse architecture?

571


What are situations where snowflake schema is better than star schema when the opposite is true?

560


what are the others of "bad files" and "discard files" when using sql*loader?

1622


Suppose your client wants to ensure only specific users can create reports in query studio with other users creating reports using report studio. How can this be accomplished?

484


Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?

530


How can we run the graph? How can we schedule the graph in unix?

496


What are aggregate tables and aggregate fact tables?

520


Explain vldb?

621