DSXchange

:!: Simply repeating your post doesn't help any of us understand it better. Your example doesn't seem to match up to your words. "1 out of 2 records" means what exactly - every other record? Every even? Every odd? Something else entirely? All your example shows are the first two records be...

Ah... I can see why your performance seems to be fine with this change, you are working with what basically is an insignificant number of rows. I was assuming the number was... much larger.

However, if it points north for more than four hours you may want to see a doctor.

I can change only one parallel job That seems like a very... odd... restriction. And the mechanism you were 'forced' to use (Change Capture with INSERT/UPDATE/DELETE) is pretty much the polar opposite of a simple truncate and load. But if that is working for you without 'impacts on performance' the...

Use two jobs.

Off to your own post with you...

Not sure if there are a ton of Netezza users here, I was never one. :( Does the stage have any kind of "case sensitivity" property? Looks like it does which is why (I assume) the names are double-quoted. Since you specifically noted parallel reads, I'm curious if that means non-parallel re...

True. Took advantage of that fact many times.

:idea: Your post has the OS marked as Windows, you should in the future put 'Unix' there as it denotes the server operating system. You mean the Execute Command stage, correct? There is actually a Command stage but it only exists if your server is on Windows and that is what you found the documentat...

So... you are looking for a way to truncate the target table only once the data is ready to be loaded so it doesn't spend so long empty? There really isn't a way to do that 'using only one parallel job' as to do that you'd need to extract your source data elsewhere, say to a dataset and then once co...

So... by "hosted on a Microsoft directory" you mean it is on a Windows machine, correct? Is that directory mounted (NFS/Samba/whatever) on the ETL server? As far as I know you would need to do that and then you would be able to use ODBC (provided you had the proper driver on the ETL server...

Silly question perhaps but did you try changing the threshold? Can't tell from your reply. And how much RAM do you have on the box?

Do people not search anymore? This question was asked a couple of days ago and I would imagine the same answer applies:

viewtopic.php?t=154597

Index... if by 'command' you mean 'function'.