DSXchange

OK...I will try to be concise... I need to launch a series of jobs (currently 1 job designed as multi-instance) that creates a one target table each instance, based on specific criteria. One criteria is that one table must be created by company SITE, that will be found in a source file. This also me...

the DB is Oracle

Hello, I am populating a financial application, that requires a high degree of accuracy for obvious reasons... I have a required field of Float datatype, that has some data quality issues at the source, in that the source value is coming as a zero...however, zero is not an acceptable value for the a...

Hello, I have been told by a colleague there is a document somewhere on this forum stating that for some versions of 7.x and certainly for V8, the NOTFOUND function will no longer be valid I have looked, but cannot find it. has anyone heard anything on this? I can imagine this could have a substanti...

All you would need to do is create a output link to a sequential file, set up the constraints appropriately and put the stage variables in the derivation for the appropriate columns in your file. Also, the formulas can be stored in columns as varchars. I have tried that solution already, but when I...

Hi, all, I am trying to figure out how to retrieve the value/formula contained in a Stage Variable. I am using Stage Variables for Reject logic, and I would like to use the logic I have entered to populate a table for supplementary information for error reporting. I would like to end up with a file ...