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 the sortmerge collector?

0 Answers  


How to remove duplicates in transformer stage? in parallel mode

6 Answers   Syntel, TCS,


What is apt_config in datastage?

0 Answers  


What is the diff between sort performed at sort stage and the stream sort performed at the input of few stages in DS Enterprise edition?

1 Answers  


What is difference between server jobs & parallel jobs?

0 Answers  






Enlist various types of routines in datastage.

0 Answers  


when we have to go for a sequential file stage & for a dataset in datastage?

1 Answers  


Please explain me the difference between 3 types of slowly changing dimension in datawarehousing?

3 Answers   TCS,


What's the Main Function of the Staging area in DWH

3 Answers   Oracle,


I have 3 jobs A,B and C , which are dependent each other. I want to run A & C jobs daily and B job run only on sunday. how can we do it?

1 Answers   CGI,


what is the function in Transformer stage can act as Rank function in Oracle

1 Answers   Reliance,


in source is like seq file in date column have dd-mm-yy dddd-mmmm-yyyy mm-dd-yy yy-dd-mm yy-mm-dd i want to display only yy-dd-mm date formats only in tgt?

2 Answers   Wipro,


Categories