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's the Main Function of the Staging area in DWH
What is a folder? Difference types of stages?
How can we improve performance of data stage jobs?
diff between OLTP and OLAP? what TOP-DOWN and BOTTOM-UP Approach? which is best? what are Star Schema and Snow Flake Schema?
Hi friends,Two input files, wants to validate only if the reference data has '0' otherwise no validation should be done..how to do this??
source file having the data like aabbccc, i want target file result like a1a2b1b2c1c2c3.
What is exact difference between Parallel Jobs and server Jobs..
hi, 1)totally how many jobs created in ur project 2)what is ur datamart size & Dwh size 3)How secure ur project 4)could u plz tell be about testing process after complete the job will run sucessfully or not in Datastage
What is the function in Transformer stage can act as Rank Function in oracle
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
How to convert RGB Value to Hexadecimal values in datastage?
what is the main difference between sorragate key n primary key in one word