Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

when U have a remove dublicate option in sort stage, why we have a remove dublicate stage in PX, thought it is recamended to sort data before using a remove dublicate stage. I hae been thinking this from days....

4 Answers   Target,


we run a job in 4 nodes,i want to run same job on 8 nodes is it possible? job recompling is mandtory?why?

1 Answers   HSBC, NTT Data,


how to find diff between 2 dates without using Icon... funtions?

1 Answers  


Which algorithm you used for your hashfile?

0 Answers  


how to convert rows into columns

2 Answers   IBM,


Define meta stage?

0 Answers  


What are transforms and what is the differenece between routines and transforms?

0 Answers  


what is a force compile

2 Answers   Cap Gemini, IBM,


Hi friends,Two input files, wants to validate only if the reference data has '0' otherwise no validation should be done..how to do this??

1 Answers   IBM,


What is the difference between lookup and sparse lookup?

1 Answers  


What is size of a transaction and an array means in a datastage?

0 Answers  


Hi guys, Design job sequence, we have 3 sources, in that 1st source in abort then only run the remaining sources.. How please design the job. Thanks.

2 Answers   IBM,


Categories