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 are the types of views in datastage director?

1247


Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

619


What are the areas of application?

658


Terminate Activity

839


On which Dimension Table you implemented SCD Type in your Project

1577






How many areas for files does datastage have?

640


What are the main differences you have observed between 7.x and 8.x version of datastage?

622


What is job control?

622


Can you implement SCD2 using join, transformer and funnel stage?

1085


Can you explain players in datastage?

703


What are the different types of lookups in datastage?

628


Explain entity, attribute and relationship in datastage?

635


What are the enhancements made in datastage 7.5 compare with 7.0?

707


Which commands are used to import and export the datastage jobs?

981


Can you explain kafka connector?

775