Source has 2 columns:
USA,NewYork
INDIA,MUMBAI
INDIA,DELHI
UDS,CHICAGO
INDIA,PUNE
i want data in target like below:
INDIA,MUMBAI1
INDIA,DELHI2
INDIA,PUNE3
USA,NEWYORK1
USA,CHICAGO2
No Answer is Posted For this Question
Be the First to Post Answer
4) source target c1 c1 c2 c3 c2 c4 c4 c5 c3 c6 c7 c4 c5 c6 c7 please send me answer this question my mail
what is the use of surogate key in datastage
What is process model?
What are the functionalities of link partitioner?
How to Convert the columns into rows?
Define ds designer?
i have source data like empno,enmae 11 ,aa 12 ,bb i want output like empno,ename 11 ,aa 12 ,bb 11 ,aa 12 ,bb
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?
i hav source like this . deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like this target1 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformer
Hi any one has datasatge 8.5 certication dump could you please provide your details i will contact you. send reply to my mail rajaadivi@gmail.com Thanks in Advance
What is "fatal error/rdbms code 3996" error?
Out of 4 mill records only 3 mill records are loaded to target and then job aborted. How to load only those 1 mill(not loaded records) for next run. This job is not sequential job, it is stand alone parallel job.What are the possibilities available in datastage8.1?