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

Answer / prasad

MadhavaReddy, who gave logic that is correct.

I tried, got exact result.

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.

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

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

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)

What is ds designer?

1 Answers  

how to change left and right links in join stage?

4 Answers   Cap Gemini, IBM,

Different ways a project can be moved to production ?...example ….export-import and Version control.

1 Answers  

What is the process of killing a job in datastage?

1 Answers  

I have a few records just I want to store data in to targets cycling way how?

1 Answers   Polaris,

How do u convert the columns to rows in datastage?

1 Answers  

In Datastage, how you can fix the truncated data error?

1 Answers  

Difference in the implementation of lookup and join stages,in joining two tables?

7 Answers   TCS,

What can we do with datastage director?

1 Answers  

deptno wise to find max and min,and sum of rows and in target to company wise maximum

1 Answers   IBM, TCS,

how many types of remove the duplicate records?

3 Answers   Caterpillar,

What is orabulk stage?

1 Answers