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



Hi, I have 3 records, 1 Srini 1 vasa 2 reddy now i want o/p like this 1 Srinivasa 2 ..

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

Hi, I have 3 records, 1 Srini 1 vasa 2 reddy now i want o/p like this 1 Srinivasa 2 ..

Answer / prasad

MadhavaReddy, who gave logic that is correct.

I tried, got exact result.

Is This Answer Correct ?    0 Yes 0 No

Hi, I have 3 records, 1 Srini 1 vasa 2 reddy now i want o/p like this 1 Srinivasa 2 ..

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

Hi, I have 3 records, 1 Srini 1 vasa 2 reddy now i want o/p like this 1 Srinivasa 2 ..

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

Hi, I have 3 records, 1 Srini 1 vasa 2 reddy now i want o/p like this 1 Srinivasa 2 ..

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

Hi, I have 3 records, 1 Srini 1 vasa 2 reddy now i want o/p like this 1 Srinivasa 2 ..

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

Post New Answer

More Data Stage Interview Questions

What are iconv and oconv?

0 Answers  


How do u convert the columns to rows in datastage?

0 Answers  


how do u capture duplicates through sort & transformer

4 Answers  


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

2 Answers   Wipro,


What are system variables and sequencers in datastage

0 Answers  






Have you have ever worked in unix environment and why it is useful in datastage?

0 Answers  


To see hidden files in LINIX?

0 Answers   CTS,


IS FILE SET CAN SUPPORT I/P AND O/P LINK AT A TIME?

1 Answers  


How to remove duplicates in transformer stage? in parallel mode

6 Answers   Syntel, TCS,


i have 4 jobs i want run 1job should run on 1node and 2job runon 2node and.... how to make it possible?

1 Answers  


What could be a data source system?

0 Answers  


Differentiate between operational datastage (ods) and data warehouse?

0 Answers  


Categories