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 |
What are the some differences between 7.x and 8.x version of datastage?
In my previous project we get data from mainframe and load it into datastage DB2 tables.Sometimes we get data as flat file or a mainframe tables itself directly we fetch the data.Is this a migration project?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
what is the new version in Datastage ? what is the diff b/t New vesion & 7.5 version?
What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?
what is the use of surogate key in datastage
source which format u will get either fixed or delimiter length format? what is the symbol of delimiter?
How do you import and export data into datastage?
Explain Quality stage?
How to get max salary of an organization using data stage stages........... can any body help me plz.......
Wat is isolation level and when do u use them?
What r the existing server jobs in parallalism?