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


Please Help Members By Posting Answers For Below Questions

What is the differentiate between data file and descriptor file?

871


To see hidden files in LINIX?

948


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)

1905


Highlight the main features of datastage?

619


How can we improve the performance in datastage?

656






How can you write parallel routines in datastage PX?

624


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

554


What is a merge in datastage?

774


How do you run datastage job from the command line?

607


Differentiate between validated and Compiled in the Datastage?

653


What is difference between symmetric multiprocessing and massive parallel processing?

662


How to reverse the string using unix?

2818


How the ipc stage work?

680


what are .ctl(control files) files ? how the dataset stage have better performance by this files?

2187


What could be a data source system?

581