DSXchange

So... this is something that has never worked, or was working correctly and has now stopped working?

I was thinking of going about it using the database. i.e. identify the records loaded last night (multiply the no of records with the bytes that each record takes.) What number of bytes - the full size according to the metadata? The Average Record Length derived from the data itself? Or by summing ...

Perhaps because Informatica does?

I've never found it all that useful, honestly, but it is shown in their monitor. Would also be curious as to the why of this.

Gibberaltar, actually.

ps. That removes any files that haven't been 'accessed' in 7 days. In case you don't speak UNIX gibberish.

FranklinE wrote:Craig, I now have significant experience with CFF stage, and have a short list of additions to the FAQ available. Let me know how you wish to use it.

Send me the additions in a PM and I'll add them to the FAQ, that or send me a fully revised FAQ if you prefer and I'll replace the contents.

Perhaps this FAQ entry will help.

:? That's... odd. You're actually telling it to add more message types to the log, that 2 adds DEBUG information on top of everything else. I would assume you need to go back to your official support provider for that one, seems patch-worthy to me. As an aside, in my current tool I've seen problems ...

You delete any unneeded files from the directory. And files there are only needed while the associated job is running.

boxtoby wrote:I would be grateful if you could tell me what these files are and how can I get rid of them or manage their size?

Also, involve your DBA.

I marked it as resolved because of the rating on your previous post: "Solved my problem!". Hover your mouse over it.

oracledba wrote:please check other posts

viewtopic.php?p=358261

I'm curious how the linked post applies to this particular issue / error message... it doesn't really seem to unless I'm missing something.

Not to sound facetious, but... add a status link? If you don't really care about it, perhaps just stub it into a Peek stage.

Did you get an answer on this?

Have you applied the fixpack noted in the second support link?