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 |
What is the purpose of pivot stage and types of containers in datastage
1.How to read multiple file from sequential stage. 2.If a file doesn't arrive or doesn't exists in sequential stage how do u handle this. 3.What do you do before taking data from source to staging area. 4. I have a remove duplicate stage and transformer stage.what will u do for optimizeing the performance of the job.
What is process model?
What is the use of datastage director?
INPUT file 'A' contains: 1 2 3 4 5 6 7 8 9 10 input file 'B' contains: 6 7 8 9 10 11 12 13 14 15 Output file 'X' contains: 1 2 3 4 5 Output file 'Y' contains: 6 7 8 9 10 Output file 'Z' contains: 11 12 13 14 15 How can we implement this in a single ds job?
What is the use of hoursfromtime() function in transformer stage in datastage?
Explain the ChangeApply stage?
What is the difference b/w Hash file and Lookup Fileset stages?
To see hidden files in LINIX?
Hi friends If anybody completed datastage 8.5 certification.Could please guide me what are the topics new in 8.5 certification.
Enlist various types of routines in datastage.
detail about sdlc