why do we need a datawarehouse when we have databases to store
data?



why do we need a datawarehouse when we have databases to store data?..

Answer / 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

More Data Stage Interview Questions

How do you get log info into a file?

1 Answers  


how can i get 2nd highest salary in datastage?can u send me ,thanQ 2)if i had source has 2 records 1st record ie 1st column contains 1,2,3 and 2nd coulmn contains 10,10,10 i have to get target as 2nd columns as 20,30,40 how can i?

3 Answers   Accenture,


How one source columns or rows to be loaded in to two different tables?

0 Answers  


Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result "SCH-AS" in onee column and "1010" in another column.. Can any one tell the answer...

5 Answers  


i have source like balance,drawtime 20000, 8.30 50000,10.20 3000,4.00 i want target like this balance,drawtime 20000, 20.30 50000,22.20 3000,16.00

2 Answers  






IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?

3 Answers   Infosys,


What is the command line function to import and export the ds jobs?

0 Answers  


Where the datastage stored his repository?

0 Answers  


Hi guys, 7. how to get this output i/p col1,col2 101,a 102,b 103,c 104,d o/p col1,col2 101,d 102,c 103,b 104,a Thanks

2 Answers   Cap Gemini, IBM,


What is the difference between lookup and sparse lookup?

1 Answers  


How to add zero "0" before record in a field?

4 Answers  


What is the difference b/w Hash file and Lookup Fileset stages?

1 Answers  


Categories