what is the difference between enterprise data warehouse
and data warehouse
Answers were Sorted based on User's Feedback
Answer / vijay kalyan.v
Enterprise Data ware house is built for Entire Organization
and mostly has Departments as Data marts. Ex: Sales, Fin,
Operations, Logistics, HR, CRM....
A Normal data warehouse is built for specific problems to
give proper data (Cleaned and Historical) for reporting
tools. Ex Sales DWH (For In death Sales Analysis)
Is This Answer Correct ? | 13 Yes | 2 No |
Answer / patrik lager
What Vijay presents is in my opinion a process/function
oriented data warehouse.
Within a Enterprise Data warehouse the information is
system, process independent and at atomic level. That gives
you the power to support all process but also the ability
to easier do crossprocess analytics and do CPM.
/Patrik
Is This Answer Correct ? | 4 Yes | 1 No |
Answer / g
Enterprise Dataware house is a dataware house built for
only that enterprise
Is This Answer Correct ? | 2 Yes | 7 No |
Answer / abd hfz
Enterprise Data warehouse is a Data mart which is to
specific application like department.
Data warehouse is a subject oriented.
Is This Answer Correct ? | 0 Yes | 5 No |
how to add a new query item by using 2 query subject? For Ex: i want to create a revenue query item in products query subject(revenue=Quantity*Unitprice). Quantity is in products query subject & unit price in orders query subject it will be possible in report studio(perment/temporerally) otherwise u have create in Freamework Manager... pls any body knows explain /answer me ?
Difference betwween cognos report net architecture and cognos8 architecture
what is a box type in cognos? what is a stitch query? what are the services that run in background when cognos is running
Where do i get Free COGNOS 8 Certification Dumps Downloaded for these codes COG-105, COG-112, COG-122, COG-125, COG-132, COG-135, COG- 142, COG-145, COG-180, COG-200, COG-205, COG-300, COG-310, COG-400, COG-480
What is the complex report you faced in real time?
if at all asked.wat is u r cube name?wat would be a appropriate answer? plz help me
Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?
write a query to display the third record from the employee table?
what is prompt variable
which table we load first in DW. dimension or fact? why?
4 Answers IBM, JPMorgan Chase,
Explain about embedded & standalone filters?difference between them
Define the slice and dice?