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

Post New Answer

More Data Stage Interview Questions

What is datastage?

0 Answers  


What are the environmental settings for data stage,while working on parellel jobs?

2 Answers   Satyam,


How did you reconcile source with target?

2 Answers   HP,


where we use config file as parameter ?

1 Answers   IBM,


how many write modes are there in ds

2 Answers   IBM,






Can we use Round Robin for aggregator?is there any benefit underlying?

3 Answers   TCS,


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...

5 Answers  


Explain connectivity between datastage with datasources?

0 Answers  


which is the most complex job in your career? Please tell me answer?

2 Answers   IBM, Wipro,


which cache supports connected & un connected Lookup

1 Answers   Wipro,


what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs?

9 Answers   HCL,


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,


Categories