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 the use of incremental aggregation? Explain me in brief with an example?
Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?
Which is the optimized method of extracting the data.
What is a ETL/ How does Oracle support the ETL process?
Difference between slicing and dicing with example?
What is DTM session?
What is VLDB?
What is the difference between Oracle Express and Oracle Discoverer?
for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?
Difference between cold fusion mx 6 and cold fusion mx 7?
Do you view contain data?
Why facts table is useful in representing the data?