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
What is quality stage?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
What is datastage engine?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
Explain the importance of surrogate key in data warehousing?
What is a folder? Difference types of stages?
What are the functionalities of link collector?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
What is the method of removing duplicates, without the remove duplicate stage?
What is active and passive stage?
Name the command line functions to import and export the DS jobs?
How do u convert the columns to rows in datastage?
what are the errors,warnings in datastage
What is the difference between informatica and datastage?