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.
Answers were Sorted based on User's Feedback
Answer / madhavareddy
seqstage->sortstage->transformerstage->removedupicatestage->targetdataset
sortstage->put chagekeycolum=true
transformer -> stagevariable->sv1 if change key colum =1 then in.column else sv1::in.column
in derivation colum give ->sv1
then in remove duplicate stage keep last record option
then you will get desired output
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / prasad
MadhavaReddy, who gave logic that is correct.
I tried, got exact result.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
Answer / radhakant kumar
hey it is just a example it could be like this..
1 Srini
1 vasa
1 aaaaa
the complete solution will be
say col1 and col2 so define stage variable in transformer
col1--------------->a(interger)
col2--------------->b(varchar)
if a=c then d:b else ''-->e(varchar)
e----->d(varchar)
a----->c(integer)
then in target pass e value to col2 and map col1 to col1
Is This Answer Correct ? | 2 Yes | 5 No |
Answer / 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 |
Answer / satya
Make U r source file as SOURCE and LOOKUP Files then
Make lookup on key(in u r question first column),if u find
then concatination of u r source value and u r look up VALU
(Srini:Vasa)
Is This Answer Correct ? | 1 Yes | 7 No |
What are iconv and oconv?
How do u convert the columns to rows in datastage?
how do u capture duplicates through sort & transformer
how to clear the source file? 2) diff b/t odbc & Oracle?what is node? 3) explain one complex job u face in ur project
What are system variables and sequencers in datastage
Have you have ever worked in unix environment and why it is useful in datastage?
To see hidden files in LINIX?
IS FILE SET CAN SUPPORT I/P AND O/P LINK AT A TIME?
How to remove duplicates in transformer stage? in parallel mode
i have 4 jobs i want run 1job should run on 1node and 2job runon 2node and.... how to make it possible?
What could be a data source system?
Differentiate between operational datastage (ods) and data warehouse?