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)

How To find the location of APT_confid file

2 Answers   CTS,

What are the types of containers and how to create them?

0 Answers  

what r the sources u need to create the datastage?

1 Answers  

how can we create a Sorrogate key in transformer stage? I want it in parallel mode

2 Answers   Syntel,

how to find diff between 2 dates without using Icon... funtions?

1 Answers  

what is the difference between datasatge and datastage TX?

6 Answers  

what is parameterset?

4 Answers   Wipro,

What are the steps needed to create a simple basic datastage job?

0 Answers  

Hi Every one, I have a scenario plz suggest me 1)On daily we r getting some huge files data so all files metadata is same we have to load in to target table how we can load? 2) One column having 10 records at run time we have to send 5th and 6th record to target at run time how we can send? Hi plz help me for above scenarios and If any one is having JobSequence kindly send me one example and the scenario to my mail ID(nrvdwh@gmail.com)

3 Answers   HSBC,

i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

0 Answers  

explain about citrix scheduling tool in datastage

0 Answers   HSBC,

Where do you see different stages in the designer?

0 Answers