how to use self join using datastage ?
can u tell me using stage how can we implemnet the self join
No Answer is Posted For this Question
Be the First to Post Answer
Hi Every one, I have a scenario plz suggest me 1)On daily we r getting some huge files data so all files metadata is same we have to load in to target table how we can load? 2) One column having 10 records at run time we have to send 5th and 6th record to target at run time how we can send? Hi plz help me for above scenarios and If any one is having JobSequence kindly send me one example and the scenario to my mail ID(nrvdwh@gmail.com)
where we use config file as parameter ?
explain about citrix scheduling tool in datastage
in datastage interview qustion source target ------- ------- 12345 1 2 3 4 5
difference between function and procedure...
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
Hi I have scenario like this s/r table T/r table ename,sal empno,ename,sal vijay,2000 1 , vijay, 2000 kumar,3000 2 ,kumar , 3000 ravi ,4000 3 ,ravi , 4000 How can i get target table like that without using Transformer stage?
diff between changecapture & diffrence stage which situvation we can use the diffrence stage ?
WHAT ARE THE COMMON ERRORS IN DATA STAGE?
In aggregator stage,to find the sum of the entire group of columns,it displays in binary format. How can i solve this problem.
Hi guys, 7. how to get this output i/p col1,col2 101,a 102,b 103,c 104,d o/p col1,col2 101,d 102,c 103,b 104,a Thanks
Unix command to view the data in a dataset