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 |
wt is the difference between swith and filter stage
How to Convert the columns into rows?
How do you register plug-ins?
How can we improve performance of data stage jobs?
What is RCP?
What are the components of ascential data stage?
Differentiate between data file and descriptor file?
I have oracle enterpaise stage, oracle bulkloader stage, ODBC stage and I want to load data in to target, which of the above stages do I need to use and why?
1.How to read multiple file from sequential stage. 2.If a file doesn't arrive or doesn't exists in sequential stage how do u handle this. 3.What do you do before taking data from source to staging area. 4. I have a remove duplicate stage and transformer stage.what will u do for optimizeing the performance of the job.
How do u convert the columns to rows in datastage?
why dataset ?
Describe routines in datastage? Enlist various types of routines.