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

sed,awk,head

970


What can we do with datastage director?

675


How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

2995


Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1122


What all the types of jobs you developed?

667






Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

1764


How do y read Sequential file from job control?

14419


how can we create rank using datastage?what is the meaning of rank?

8191


Distinguish between informatica & datastage. Which one would you choose and why?

587


What is job control?

624


Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

627


What are the functionalities of link partitioner and link collector?

600


Describe the architecture of datastage?

572


What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

1637


There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

1809