DSXchange

Re-partition before target stage. You may have duplicates in data...

Thanks

I don't think it is possible. One way is you can create dummy file after completion of job. based on dummy file arrival, Run a batch job to refresh BO.

Before aggregator, you need to select hash partition with correct partition keys if you are using multinode config file..

Hi,
I think you need to use string[max=50] instead of string[50]. If you use string[50] then datastage will consider as char(50) and will expect 50 characters data.

Thanks