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 |
Explain conformed fact?
What is the difference between data warehouse and operational systems?
In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?
Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?
What is core dimension?
Explain what are necessary tasks to install reportnet software?
What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?
What is the difference between ods and oltp?
What are situations where snow flake schema is better than star schema to use and when the opposite is true?
what is data validation strategies for data mart validation after loading process
What is the capacity of power cube?
How to export mappings to the production environment?