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 the sortmerge collector?
How to remove duplicates in transformer stage? in parallel mode
What is apt_config in datastage?
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?
What is difference between server jobs & parallel jobs?
Enlist various types of routines in datastage.
when we have to go for a sequential file stage & for a dataset in datastage?
Please explain me the difference between 3 types of slowly changing dimension in datawarehousing?
What's the Main Function of the Staging area in DWH
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?
what is the function in Transformer stage can act as Rank function in Oracle
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?