DSXchange

Based on my experience during DS version upgrade from 8.1 to 8.5. We had to make some minor changes. Its always advised to test all the scenarios to make sure its working as expected.

I am not sure about 8.1 to 9.1.

Hi, We are processing a file which has more than 1500 columns in it. Please let me know the complications we might be facing while processing these types of files. Planned approach for processing. 1) Split the file into 5 pieces (for ex 1-300 columns in first file 301-600 columns in second file &...

What is the largest number that will appear in column #3? What should happen if column #2 is not precisely divisible by column #3? ... - Largest number that will appear would be 4. - If column #2 is not precisely divisible by column #3. This scenario will not be occurring in our case. Please let me...

We have requirement like below, the records are in aggregated format and we need to reverse the aggregation process.

For Ex. Input
a,2000,2
b,1500,3

output
-- a,1000
-- a,1000
-- b,500
-- b,500
-- b,500

Please let me know how to acheive this in datastage. Thanks a lot in advance.

Hi Keshav,

Thanks for your suggestions.

We have a scenario where in we need to abort the process if we come across any scenarios like this.

Hi, How do we handle the below mentioned scenario in source sequential stage. Soure file of variable length having comma delimiter and quote = single. for ex Proper file --- >> 'a','b','c','d' If we get a file with a record like below for ex Invalid file --->> 'a','b,'','d' here quote for the third ...

Hi prabhu_dc, Enable Output Reject Records, In the target DB stage & Load the rejects to a dataset. After loading to Reject dataset, Check the SqlCode ( View Data of Reject Dataset will provide you the SqlCode ) for the exact DB error code. Once you have the error code, check the corresponding e...

We have supported C++ Compiler installed.

The problem was in the data type validations in the Stage variables. Same has been fixed.
Now the job is compiling & working.

I will mark the topic as resolved.

Thank you.

While compiling the job, We are getting Compilation error. Please find below the details. Output from transformer compilation follows: ##I TFCN 000001 11:05:20(000) <main_program> Ascential DataStage(tm) Enterprise Edition 7.5.1A Copyright (c) 2004, 1997-2004 Ascential Software Corporation. All Righ...