DSXchange

Hi All...

i have input as

name
%$&*BANGALORE)(_+*^

I WANTO TO GET OUT PUT AS "BANGALORE" ONLY

Can any one try for this..

Regards...

I have
Input_Column

1
2
3

I want to compare 1 with 2 and 2 with 3.....

Can any one try for this...

Regards...

I have input as

100
100
100
90
90
80
80
80

I want to give ranking for this as

100 1
100 1
100 1
90 2
90 2
80 3
80 3

How to do sorting in transformer stage?

can any one try for this?

I have input file as

1,a
1,b
1,c
2,c
2,a
3,c
3,a
3,b

I want to convert these as output

1 abc
2 ca
3 cab

can any one help me
thanks in advance...

I have input file as

1,a
1,b
1,c
2,c
2,a
3,c
3,a
3,b

I want to convert these as output

1 abc
2 ca
3 cab

I am trying to insert records from sequential file to oracle.
the metadata is aslo same,

I am gettint the error

Parallel job reports failure (code 139)

and job is getting aborted

Can any one help me.

i want to convert date format dd/mm/yyyy to mm/dd/yyyy how to doit? I have date column dd/mm/yyyy i am trying to extract it using Sequential file stage with date format then it is not able to view data when i click viewdata option then i am trying to using datatype of varchar then it is displaying d...

I have data in .csv file, this is not fixed width file.

empno should get 1,
sal should get 1,00,000
and deptno should get 11.

how to read this in sequential file stage...

empno, sal, deptno
1,1,00,000,11

Any one Plz Help me....

I want to convert the date format dd-mm-yyyy to mm-dd-yy in transformer stage, but it only displaying in yyyy-mm-dd. (I read the source date format as char from sequential file stage and now i am using StringToDate function to convert into mm-dd-yy. I am getting yyy-mm-dd only it targer and it also ...

The number of NODES increased then we have to increase the NUMBER OF CPUs is to increased? (Y/N)

How Many types of syntaxes available for date conversions in MODIFY stage.

can any one brief about this

I want to convert the date format mmddyyyy to ddmmyyyy in MODIFY stage.

can any one explain the syntax for this.

I have a date column my the source. In the comlum the date formats are mmddyy, ddmmyy,ddmmyyyy. I want to convert the column to the target as mmddyyyy there is In MODIFY Stage.

Can any one expain this.

i have one requirement that is: i have one input file that contains 100 records start from serial_number 1-100. i have another input file that contains two columns named as: Start_number & End_number and it has values as 10,50 respectively. by using these values(10,50) i want to send the input r...