DSXchange

Crouse is correct. There is a client-specific patch for XP SP2. Please contact Ascential Support to obtain a copy or use the eService web page. A copy may also be available on Ascential Developers Net's download pages.

Do not worry about this warning message if this solution is producing the right data for you. Normally, the Join Stage already handle the sort/partitioning for you, but in your observed case, it does not do the job. Maybe the datasets are sorted/partitioned earlier (and this noted behavior do propag...

Pivot Stage.

Just make sure it is standard practice for everything -- do not partition/sort data unless you have to. And when you think you have to do it, run a nice small test with a bunch of randomized data to confirm that this is indeed required. Ascential tries to minimize the need to do manual control over ...

trokosz wrote: But many companies hate ODBC due to security issues and Sarbanes-Oxley.

Security, fine, but Sarbanes-Oxley? How does that come in play here with ODBC?

I am aware and empathize with you for having someone from Ascential who did not meet up with my personal standard of quality development skills. Please repeat what I stated to the client: There are no perfect solution. Do you want to spend hours, which equals to a large amount of money out of your b...

This is a situation where DataStage is being asked to do something that it is really not designed to do. Do you REALLY want to just copy a table to another table? Then why not do it within EE's framework: [UDB] -> [copy] -> [UDB] This is a case of 'why try to fix a complicated solution that does not...

Quick and dirty method - Do it in two jobs: 1. First job - Place key fields from Item Header Record to every record immediately afterward. You will need to run this transformer in sequential mode to prevent any partitioning. You can use the Stage Variables to handle the awareness of the header recor...

PX job 1 load CustLookup into lookup dataset modulas partioned on custid PX job 2 read CUstDate -->> tfm with partion mod on cust id Please do not use manual partitioning. Lookup stage is designed to handle partitioning on its own (in fact, by default they use "Entire" partitioning). If y...