DSXchange

Suggest you talk to your DBA. Find out why deadlocks happen and what you can do to prevent them.

I would disagree with the statement that "the jobs have been successfully imported".

Exactly. Saying you changed the target column in the table to a varchar and still got "the same error" makes absolutely no sense.

ds_dwh wrote:

nagarjuna wrote:duplicates stage , sort stage , transformer stage ......

with using sequential file only

Why?

It always takes four hours or has on occassion taken that long?

Don't use a temp table? I can't imagine there's no other way to 'get count only'.

Yes, and it has been discussed here quite a bit and there was even a webinar on the subject. Searching for "automatically handle" should turn those conversations up.

However, /tmp is really where stuff like that belongs on a UNIX server. If you are having space issues there, I would make sure of two things: 1) An appropriate amount of space has been allocated for it 2) Your SysAdmins are properly managing / pruning / culling files from there Once you move files ...

Why not post the actual error messages so we can all be mislead together?

Are you certain anything is actually running, meaning you see active processes for it on the box? Or is this just your classic 'status flag be stuck' situation?

ray.wurlod wrote:We can. Overwrite the record.

I think we're more into the how than the what, Ray.

As noted, without some kind of properly maintained 'change timestamp' on the record, you'll need to select everything and then figure out for yourself what has changed by comparing the old and new values. That or use CRC32 if you don't care which field(s) have changed but just need to know that at l...

Thanks... and unless it gets more complicated, you can do all that inside the StringToDate function rather than in several stage variables.

What errors were in the job's log? What about the ".log" file from the sqlldr session? Looking for the specific reason it is not liking your data.

You are on the right track with padding the single digit months/days with a leading zero so it matches the format mask the conversion function needs. You can simplify what you are doing (using syntax that I don't recall off the top of my head but which has been posted here numerous times) but it sti...