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 |
AGGREGATOR default datatype
1.how to generate even numbers in surrogate or tranformar stage ? 2. how many ways to remove duplicate values?
I WANT TO SEND SYSDATE AS PARAMETER,SO WHAT COMMAND I SHOULD USE TO CALL SYSDATE?
What is the use of hoursfromtime() function in transformer stage in datastage?
What is the purpose of interprocessor stage in server jobs?
If I make any changes in the parallel job,do I need to implement the changes in the sequencer job,else the changes will be reflected automatically
detail about sdlc
1. How many People are part of your Team? 2. Explain how you create jobs or flow of project? 3. Join Stage vs Lookup vs Merge Stage 4. Summation scenario based question - How you find sum of salary for a specific employee (Explain stages and flow of job)? 5. Explain Remove duplicates stage ? Can you do sort in this stage? 6. SQL Questions - Joins - Types, Difference between Join and Union 7. Unix Questions - How you run the Job, How you list all jobs in project 8. Explain Environmental Variables? 9. SQL Scenario - If you have 3 Identical record in a Table, Ex: 1, Ram, Xyz; 1, Ram, Xyz; 1, Ram, Xyz; Delete only 2 of the records and keep only 1 using the Delete query. How you will you do this?
Define Data Stage?
What is a quality stage?
How do you schedule or monitoring the job?
difference between server shared container and parallel shared container