DSXchange

The offset was incorrect! Thanks for your help

Hi there I get the folowing message when reading a Complex File cff_BLUSOCD,0: Field "SERSID" has import error and no default value; data: {f0 f0 f9 f3 f0 f7 f0 f1 f4 f9 @}, at offset: 9 The field (SERSID) is a numeric field (Decimal) and it doesn't have a default value ...not sure what de...

it works, thanks!

Hi there I have the following Case statement that I need to translate in a Stage Variable case when substr(in_date_numeric, 7, 2) between '01' and to_char(last_day(to_date(substr(in_date_numeric, 1, 6), 'YYYYMM')), 'DD') then to_date(in_date_numeric, 'YYYYMMDD') else null end else null end in_date S...

Thanks for your reply Ray I want to do it in DataStage, as a proof of concept. Both snapshots are in the same database. Their size is bigger than I thought at the beginning, they have arround 20 mil rows each. By comparing the earlier snapshot to a latter snapshot we can get the static set and the c...

Hello there

I'm trying to compare a new snapshot table (Oracle) with the previous, geta delta and then apply the delta to a destination table

The size of the snapshot(s) is quite big, 2-3 mil rows.

Which approach do you recomand? using datasets, Outer Joins?...

Thanks for your assistence
D