what is the definitions for Datawarehose and Datamart?
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 |
count number of deptno in a emp table?
in source is like seq file in date column have dd-mm-yy dddd-mmmm-yyyy mm-dd-yy yy-dd-mm yy-mm-dd i want to display only yy-dd-mm date formats only in tgt?
What is the method of removing duplicates, without the remove duplicate stage?
what is repositery?
how CAN we remove duplicates in dataset?
In Sequential file, how can i split a column into two, and that column contains string datatype. For Example, i have column of string datatype as subedar khaja. Now i want get output as separately with subedar in one column and khaja in second column. How? Coula anybody, solve it?
what is the new version in Datastage ? what is the diff b/t New vesion & 7.5 version?
How do you load 10 different sources with 10 different layouts to 10 different tables?
What is data partitioning?
source 1123445 I WANT OUTPUT AS DUPLICATES TO TARGET1 LIKE TARGET1 1144 NON-DUPLICATES TO TARGET2 TARGET2 235
how to find out number of records imported into source file?
What are sequencers?