DSXchange

If you attempt to evaluate nulls within a transformer PX will drop those rows automatically. Before running any functions or evaluations on a suspect null value check for nulls before you process.

I know you guys have already touched on performance, but l would just reiterate that the XML parser in DataStage is very slow. As Ray said stick to flat files.

In case you havnt resolved this problem, what we have found is that numeric data type in PX pre-pends a space for the +- pushing the digits right hence causing your last digit to become a 0. E.g numeric(15) "123456789012345" passed through trnasformer and output to a sequential file will r...

Does anyone have performance stats on enterprise vs multiload. Rumour has it that enterprise is faster at inserting new records however it doesnt have the capability to update. Any comment ?

Most of our load jobs use multiload, l'm looking for opportunities to improve performance any ideas ??

PREVDTD and PREVDELETOR columns store the information when objects were deleted however the objects l am after do not show up in the SELECT query... is it possible that after the DS server as been bounced the Audit log information is removed for deleted objects ???

Thanks for that Ray, although very useful for existing jobs and routines. The information l was after were deleted objects ??? are these audit logs also stored somewhere ???

I need to find out when a certain custom stage had been created and deleted from one of my projects. Is there anything in the UV database that stores such information ??? basically something that logs actions that users have performed on the project ?? even if there is a log of what has been importe...

Thanks T.J, but that would be only part of the solution though l would still have one of those duplicates hanging around in my data. The objective is to remove all instances. I have the aggregator and transformer stages doing this for me but l cant all the rejected rows. I might have to use the chan...

I am trying to remove all instances of duplicates from my data but yet retain the duplicates as rejects. Seen as the removeDups stage does not support reject links and has to either retain first or last records of the duplicate l can't use this.

Has someone implemented something like this ??

From what l can see Teradata Enterprise cannot perform updates on a table ?? can someone confirm this ??

Furthermore does anyone know if Multiload out performs enterprise ??