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 / narayana kota
Hi
you can do this job using Pivot Stage convert these rows in
Columns by specify the column name in pivot stage as
first_column ,second_column and third_column and using
tranformer stage concatante first_column and second_column
using stage variables and pass to target.
if any method is there plz let me known
Regards
Narayana Kota
pnarayana12@gmail.com
| Is This Answer Correct ? | 2 Yes | 6 No |
Post New Answer View All Answers
What all the types of jobs you developed?
Differentiate between datastage and informatica?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
What are the some differences between 7.x and 8.x version of datastage?
Which commands are used to import and export the datastage jobs?
Explain usage analysis in datastage?
What are the important features of datastage?
describe the Steps to confiure a Qlogic switch
What are the various kinds of the hash file?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
Define project in datastage?
State the difference between an operational datastage and a data warehouse?
What is the method of removing duplicates, without the remove duplicate stage?
What is difference between symmetric multiprocessing and massive parallel processing?
Describe stream connector?