Difference between data warehousing and olap?
No Answer is Posted For this Question
Be the First to Post Answer
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
Can you implement SCD2 using join, transformer and funnel stage?
How do you import and export data into datastage?
what is the function in Transformer stage can act as Rank function in Oracle
How can you join flat file, oracle as a sources?
Have you have ever worked in unix environment and why it is useful in datastage?
how to call routines in stages?
hi my source is:: empno,deptno,salary 1, 10, 3.5 2, 20, 8 2, 10, 4.5 1, 30, 5 3, 10, 6 3, 20, 4 1, 20, 9 then target should be in below form... empno,max(salary),min(salary),deptno 1, 9, 3.5, 20 2, 8, 4.5, 20 3, 6, 4, 10 can anyone give data flow in data stage for the above scenario.... thanks in advance...
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
What is the difference between operational data stage (ods) and data warehouse?
What is audit table?
How can we run same job in 1 day 2 times