why do we need a datawarehouse when we have databases to store
data?
Answer Posted / sriram
Database contains data called production data mostly and we can do operations but not recommended which is a performance issue and is always busy with application data
where as in DW,the data which we maitain is called historical data, on which we can play around.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the differentiate between data file and descriptor file?
To see hidden files in LINIX?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
Highlight the main features of datastage?
How can we improve the performance in datastage?
How can you write parallel routines in datastage PX?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
What is a merge in datastage?
How do you run datastage job from the command line?
Differentiate between validated and Compiled in the Datastage?
What is difference between symmetric multiprocessing and massive parallel processing?
How to reverse the string using unix?
How the ipc stage work?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
What could be a data source system?