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 |
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....
we run a job in 4 nodes,i want to run same job on 8 nodes is it possible? job recompling is mandtory?why?
how to find diff between 2 dates without using Icon... funtions?
Which algorithm you used for your hashfile?
how to convert rows into columns
Define meta stage?
What are transforms and what is the differenece between routines and transforms?
what is a force compile
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??
What is the difference between lookup and sparse lookup?
What is size of a transaction and an array means in a datastage?
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.