DSXchange

I'm not sure there is any 'official' way to do this other than manually, which has got to be painful. One could probably cobble something together that goes through a dsx file to do this, maybe someone has already done something like this. Phil perhaps? Kim? You might also check here to see if Chuck...

FranklinE wrote:Remember: I'm using 7x, not 8x, so if 8x is different I'll be wrong...

It's not... nor are you.

No, all that means is they will all get commited at the same time: when the stage closes.

No, setting that option to true will cause the first record in the file to be skipped over.

By "not used", I'm assuming you mean that it is defined as a parameter in the job but you want to know if the job actually leverages / references it, yes?

I have.

That's not the right approach for your particular job.

It's a property in the stage and documented as well. I'm not anywhere with access so I can't quote chapter and verse where to find it but I can't imagine it would be all that hard to look up.

Worst case maybe someone else can provide the gory details.

Three files in three stages = one at a time. Use the option to skip header records in each of the stages.

If you want to load what you can, prequalify your data. Do lookups against your parent tables and only send to the target rows you know will not violate any constraints. That way you can also capture any of these 'data quality issues' in a more graceful manner rather than waiting for the DB to spit ...

So here we are in the right place now. Are you using the "File Pattern" option to read the multiple files? From what I recall, it will only skip the header record from the first file rather than all of them which I find rather... stupid. If your sed command is working, have you tried lever...

I've already given you your starting point - perform the exact search I mentioned. You'll find plenty of posts detailing both the problem and the solution. You've got the name and full path to the actual hashed file that has the issue, now you just need to fix it... and prevent it from happening aga...

Parallel job as marked or Server job as per the forum posted in?

If you are only processing one file at a time then simply tell the Sequential File stage that you have 1 header record, it will automatically be skipped.

If these tables are in the same source you can do the cartesian product in the original source sql. The dummy column is the solution for heterogeneous sources.

Vino - I pointed you to the other file as a reference, as a topic you could watch, not for you to hijack with your version of the issue. Let's keep any discussion of your errors here. Have you located the "libclntsh.so" module? Have you ensured that where it lives is included in your "...