Hi,
I have 3 records,
1 Srini
1 vasa
2 reddy

now i want o/p like this
1 Srinivasa
2 reddy

could u please help in this

Thanks in advance.

Answer Posted / gopal

In the transformer stage u can use concatination symbol for
first two records like Record1 : Record2 this is for first
column and second column u mentioned as it is.

Is This Answer Correct ?    6 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What all the types of jobs you developed?

673


What is "fatal error/rdbms code 3996" error?

667


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

356


What are the difference types of stages?

629


How do you generate sequence number in datastage?

629






EXPLAIN SCD

973


how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

4572


What is the difference between account and directory options ?

628


Define APT_CONFIG in Datastage?

669


How can we improve performance of data stage jobs?

620


What could be a data source system?

581


What are the types of containers in datastage?

707


Explain connectivity between datastage with datasources?

605


What are the types of views in datastage director?

1249


What are the steps needed to create a simple basic datastage job?

667