DSXchange

You don't need "IF" statements in a constraint, just expressions that evaluate to true or false. So, ignoring the part where we don't know what "is good" means, at a high level you would use this in the constraint: (Require_Flag for Col1 = "Y" and DataType of Col1 is Go...

I know of no reason why RTI job logs would simply "go away" unless you have auto-purge turned on and then still it wouldn't happen with the timing you are talking about. Keep in mind that RTI jobs are multi-instance jobs so each current 'invocation' will filter its own logs out of them 'ma...

Use DSGetLinkInfo() from a routine in a Sequence job to check to see how many rows went down the 'invalid' link. Only run the load job when that says '0'.

Hmmm... makes my brain hurt... but I trust you.

Probably introduced in 8.1.

So, first place to check would be your "3rd party system" and see if they are the guilty party. If not, then suspect your ftp script / process.

Got to give credit where credit is due... Ken Bland taught me that one many moons ago.

And 30 for Oracle but that's all in the database, not in DataStage.

Define 'very low performance' and describe in detail what you are doing in the transformer.

You need to figure out what added the spaces(?) to the end of the filename and fix it. Before that, you'll need to use a wildcard.

Actually, it is the fourth transformer as the crow counts.

I honestly don't think that will introduce the 'process break' you'd need to really make that work.

With DIRECT=TRUE there are no commits possible. You would need to do a 'conventional' load - DIRECT=FALSE - to be able to control the commit level. And then those are just 'normal' inserts, not really a bulk load.

No, when set to 'Oracle' the DRS stage uses OCI. When set to 'ODBC' it... well, I'm sure you can figure that one out.

Arnd, when someone does this, click on 'Reply with quote' in their original post and you'll see what they thought they were posting, ASCII art wise. They're looking for two links from a transformer to first completely process one link and only then completely process the second. You could do it in a...