Interested to Buy Any Domain ? << Click Here >> for more details...
what is the definitions for Datawarehose and Datamart?
- 4 Answers
- 8052 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / yarramasu
Datawarehouse is nothing but collection of logical data its
maintain historical data. Datamart is subset of
datawarehouse and its maintained dependent and independent
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / venugopal
DataWareHouse is a huge database to maintain the historical
data. where as Datamart is a subset of DWH.
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / sagar
Datamart is subset of Datawarehouse we can say ....a
datamart is collection of individual departmental
information...
Where as datawarehouse in collection of datamart.
| Is This Answer Correct ? | 2 Yes | 3 No |
Answer / maruthi
BASICALLY DWH ARE DOMAIN ORIENTED IN THE SENSE DWH STORES
DATA ACCORDING TO DOMAINS,SO DATA MART IS DWH OF PARTICULAR
DOMAIN(SALES,PRODUCTION,ETC)
WHEN WE GET TOGETHER ALL THIS DOAMINS OF A SINGLE COMPANY
THEN IT IS CALLED AS DWH.
| Is This Answer Correct ? | 0 Yes | 5 No |
How do you design PX Routines ?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
What could be a data source system?
how does work server jobs?
What are the types of containers and how to create them?
In my previous project we get data from mainframe and load it into datastage DB2 tables.Sometimes we get data as flat file or a mainframe tables itself directly we fetch the data.Is this a migration project?
how do u reduce warnings
how many dimentions and fact tables used in your project and what are names of it?
hi, 1)totally how many jobs created in ur project 2)what is ur datamart size & Dwh size 3)How secure ur project 4)could u plz tell be about testing process after complete the job will run sucessfully or not in Datastage
What is confirmed Dimension? what is Factless Fact? give one example? What are Additive, Semi-Additive Facts?
30 jobs are running in unix.i want to find out my job.how to do this?Give me command?
what is 'reconsideration error' and how can i respond to this error and how to debug this
Teradata 
