DSXchange

Hello everyone, I have an aggregator stage that calculates the sum of a decimal(13,2) field. Both input and output are defined as not nullable. The result of is correct, but I am getting the following warning message: Aggregator_66: When checking operator: When binding output interface field "v...

great! warnings disappeared. Thanks.

Hello everone, I am using an aggregator to count the total number of rows on a input sequencial file. It is grouped by primary keys and the aggregation type is "Count Rows", however, I am getting a warning message. ag_recordcount_audit_ag_recordcount_audit: When checking operator: When bin...

Hi everyone, I need to convert a julian date with formate yyyyddd to regular date formate, for example, if the input is 2005001, then the output is 01/01/2005. Does datastage have a built-in function to do that, otherwise I have to write my own logic, which is very complicated, because I have to con...

Hi everyone, I need to convert a julian date with formate yyyyddd to regular date formate, for example, if the input is 2005001, then the output is 01/01/2005. Does datastage have a built-in function to do that, otherwise I have to write my own logic, which is very complicated, because I have to con...

Can you do it on the Unix level? Just use wc -l filename to count the total number of lines on the input file. I need to capture the total number of rows that pass through any link in a job . For eg. 1. The number of rows from Input to transformer 2. The number of rows from Transformer to ouput1. 3....

Hi everyone,

I need to write a Datastage basic routine to lookup a hash file and return the result.

Does anyone know how I can do it?