DSXchange

For ODBC source connection in my datastage job I'm getting error as "String index out of range: -1" when i try to import the job to different server. I see that in Generated OSH script the below line. Not sure is it because of that the issue is occuring. "#############################...

Hi Team, I want my out put file to look like below: 20 11111 xxxxxx 20 11111 yyyyy datatype is, col1 char(1), col2 char(2), col3 char(9),col3 char(6) when im running my datastage job im always getting extra space after every value like below: 2 0 11111 xxxxxx for the 1st char im always getting extra...

Hi Chulett,

Sorry about saying column to row,I was confused.

I tried using vertical pivot using pivot enterprise stage,but I didn't get the desired output.


ex:
ID,A,B
1,RAM,ROBERT
1,RAHIM,SHYAM
2,JOHAN,JOHN

but my desired output is

O/P:
ID,A,B
1,RAM,SHYAM
1,RAHIM,ROBERT
2,JOHN,JOHAN

I/P:
ID,COLNAM,COLVAL
1,A,RAM
1,B,SHYAM
1,A,RAHIM
1,B,ROBERT
2,A,JOHN
2,B,JOHAN

O/P:
ID,A,B
1,RAM,SHYAM
1,RAHIM,ROBERT
2,JOHN,JOHAN

need help in designing this job.

i'm not sure on approach. trying to see anything can be done

Is there any logic without @Iteration and looping functions. can we implement using stage variables?

Thanks

Hi All, Needed a logic in transformer for the below scenario. i shouldn't use pivot stage. and needed in datastage and not using unix. I/P data: Account_numb Name Total 123 ABCDEF 123456789 345 GHIJKLMN 987654321 O/P data: Account_numb Name Total 123 AB 123 123 CD 456 123 EF 789 345 GH 987 345 IJ 65...

Hi All, Needed a logic in transformer for the below scenario. i shouldn't use pivot stage. and needed in datastage and not using unix. I/P data: Account_numb Name Total 123 ABCDEF 123456789 345 GHIJKLMN 987654321 O/P data: Account_numb Name Total 123 AB 123 123 CD 456 123 EF 789 345 GH 987 345 IJ 65...

Hi All, Job1 Activity -> In job Triggers Custom-(Conditional) is selected for both Routine Activity1 and Terminator Activity1 to check for any ORA-ERROR Job2 Activity -> In job Triggers Custom-(Conditional) is selected for both Routine Activity2 and Terminator Activity2 to check for any ORA-ERROR Jo...

Hi All, My Sequencer looks like: Job1 Activity -> In job Triggers Custom-(Conditional) is selected for both Routine Activity1 and Terminator Activity1 to check for any ORA-ERROR Job2 Activity -> In job Triggers Custom-(Conditional) is selected for both Routine Activity2 and Terminator Activity2 to c...

when i tried with AsInteger(lnk.col1) then it removed decimal point and decimal part values.

Thanks in Advance,

Will the Floor() function round up if the value after decimal point is greater than 5?

my source data contains value as "1234.56" which is of decimal(17,2) datatype. In my target table: i want only the integer part of above value appended with zeroes at the starting for varchar2(16) datatype. in target value needed is "0000000000001234" Please let me know what func...

my job is having 2 transformers. 1st transfomer gets data directly from join stage, where using round robin partition with "@PARTITIONNUM + (@NUMPARTITIONS * (@INROWNUM - 1)) + 1" it's coming correctly. 2nd transformer i'm sending data from funnel stage and in that transformer if i use &qu...

Incoming data count is unsure so rowcount on each partition wont be identical.
We are running using 4 node configuration file.