How many Key we can define in remove duplicate stage?
No Answer is Posted For this Question
Be the First to Post Answer
i have source like deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like target1 deptno,sal 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformerstage
how can or from where we can get reference data in scd type2 implementation?
What r the existing server jobs in parallalism?
Explain briefly scd type2 in datastage7.5x2(parallel)
in sequtial file 2 columns avaliable,iwant only one column load the target how do it.
parallel jobs run on cluster machines. server jobs run on smp and mpp. What do mean by cluster mechines and SMP and MPP..?
what is the diff between sequential file and fileset stages?
source file having the data like aabbccc, i want target file result like a1a2b1b2c1c2c3.
i have data like sam ram sam raj ram I want two targets trgt1 ram sam trgt2 raj how can i do this in datastage?
Difference between sequential file and data set?
Can you explain link buffering?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)