Interested to Buy Any Domain ? << Click Here >> for more details...
what is the definitions for Datawarehose and Datamart?
- 4 Answers
- 7970 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 |
my soure table is emp having columns sal,deptno in the deptno 10,20,30deptno row are there expected out put is min(sal) of 10th deptno,max(sal) of 20th deptno,mean(sal) of 30th deptno using aggregation stage
there are indexes on a table as index1 with col1, col2 index2 with col2 index3 with col1,col2,col3. if i run a query with col1='100' which index will be used and why
I have 2 Files like fileA fileB Output1 Output2 Output3 1 6 1 6 11 2 7 2 7 12 3 8 3 8 13 4 9 4 9 14 5 10 5 10 15 6 11 7 12 8 13 9 14 10 15 please let know
On which Dimension Table you implemented SCD Type in your Project
What is the process of killing a job in datastage?
what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none
Difference between ‘validated ok’ and ‘compiled’ in data stage?
what is the definitions for Datawarehose and Datamart?
How to perform incremental load in datastage?
deptno wise to find max and min,and sum of rows and in target to company wise maximum
how to remove duplicates in transformer stage by using stage variables?one example?
which cache supports connected & un connected Lookup
Teradata 
