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
What are non-additive facts in detail?
How can we run the graph?
Tell me what is degree of a relation?
Explain Association algorithm in Data mining?
What is aggregate fact table?
What is the difference between olap and oltp?
what is an use case?
What is data warehouse architecture?
What are situations where snowflake schema is better than star schema when the opposite is true?
what are the others of "bad files" and "discard files" when using sql*loader?
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?
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?
How can we run the graph? How can we schedule the graph in unix?
What are aggregate tables and aggregate fact tables?
Explain vldb?