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 purpose of pivot stage and types of containers in datastage
options available in sequence job to run,validate?
Can you explain how could anyone drop the index before loading the data in target in datastage?
Highlight the main features of datastage?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
Difference between ‘validated ok’ and ‘compiled’ in data stage?
how many rows sorted in sort stage by default in server jobs
What are the types of containers and how to create them?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
Give an idea of system variables.
Can you filter data in hashed file?
Is the value of staging variable stored temporarily or permanently?
What is the difference between account and directory options ?
What is ibm datastage?
What are the areas of application?