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
What is datastage?
What are the environmental settings for data stage,while working on parellel jobs?
How did you reconcile source with target?
where we use config file as parameter ?
how many write modes are there in ds
Can we use Round Robin for aggregator?is there any benefit underlying?
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...
Explain connectivity between datastage with datasources?
which is the most complex job in your career? Please tell me answer?
which cache supports connected & un connected Lookup
what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs?
if 3 table having different columes. like first table having 4 columns , second table having 3 columns and third table having 2 columns then how to capture the data by using funnel stage in parallel jobs...srinu.thadi
17 Answers IBM, TCS,