DSXchange

I've seen this question posted many times and there were no complete answers. So I'm writing this for the sake of closure: Importing fixed width decimal columns Set these properties in the sequential file stage: in the Format tab: 1)right click 2)select "Format as" 3)select "fixed-wid...

I've seen this question posted many times and there were no complete answers. So I'm writing this for the sake of closure: Importing fixed width decimal columns Set these properties in the sequential file stage: in the Format tab: 1)right click 2)select "Format as" 3)select "fixed-wid...

Background: I need to write this warning when the compare stage has two rows that do not match. Both input datasets will have one row each. The purpose is to see if the data matchs the balance row at the end of the file. The balance row would have a row count and a sum of some of the columns. Then I...

I just wrote that in the message above yours:

Output schema:

result : tinyint
first : unknown (these are subrecords)
second: unknonw


Runtime column propegation is checked off in the DS admin and also in the the Advanced tab of the stage.

you should use a MODIFY stage to specify explicit values for nullable columns before you send them to a sequentail file. If you don't need nullable columns in the target (assuming that your sequentail file is a reject file or something like that and your target is a dataset or DB stage) then you sho...

...you can see if you can change the default decimal format

if you're going to run a function like convert then make sure you do it in a MODIFY stage. A transformer stage is a waste of resources for something like this.

>1. How can we perform a incremental data load in datastage this is more of an ETL question and not a DS question. One method is to maintain a copy of the target table as a dataset and check for the difference with your input file every time the job starts. That will get you an incremental data set....

Is there any way to write a warning to the log in a parallel job. Not server or sequence . I know how to do that. I need to know how to do it in a parallel job. I tried the following, but they don't work in a parallel job transformer: UtilityWarningToLog() DSLogWarn() Maybe you know of something tha...

For the compare stage, all you have to do is define the following output columns: result : tinyint first : unknown (these are subrecords) second: unknonw If you don't want to use the data because all you want is the result code then you can add a MODIFY stage and specify "KEEP result". I h...

What is the best way to implement lengthy business logic in a parallel job. My specif problem is that I have an IF statement with 100 conditions each performing a different calculation. Also, the IF condition stays the same for each column, but the calculations change. Ex: In col1 IF col0=1 then col...

I am getting a "main program: segmentation fault" error in my jobs when I run them. Sometimes it gives an unhandled exception error. I have 2 lookup stages and two join stages. All lookups are done with an ODBC stage. input and output source is a sequential file stage. The funny thing is t...