DSXchange

Finished with the previous run date/time? Please add an after-job ExecSH call to the command "touch /tmp/ThisIsAnEmptyFile.txt". Then compile the job and run the job sequence. Is the state of the job still "compiled" and does that file exist in /tmp?

I am not at a computer where I can test this. What about "cast('sfsdf' as VarChar(32))"?

A decimal column doesn't have any spaces; just when displayed.

You have automated log clearing enabled.
Now that you have a job that has already run, if you re-run the script what is the last-run-time of the job you manually started? Has it changed or does it remain the same?

I haven't checked at V8 or in PX. Could be a "gotcha"

Option 2 will use less resources for the same polling period.

If you use all 6 columns for hashing, then you will get different ordering and will get different ABC column value combinations onto the same node. Just a mathematical certainty as a funciton of the hashing algorithm.

this might be a char/nchar issue on collation. Can you change your SQL to cast the results to VarChar2()?, i.e. "...select 'aa11' as VarChar(32) from dual..." and see if you get identical results?

cetzhbo wrote:...but if this null input columne appears in the output derivation, corresponding output will be rejected...

Could you explain that? NULL output columns are perfectly valid and are used all the time.

You will have to partition your data using A,B and C as keys. The number of nodes isn't relevant, just that for each node the keys used to compare with the last record are identical.

Nothing new, in server transform stages it was labelled "reject" link.

And it functions just as Craig and I have stated - if a row doesn't get output to any other link(s) then it goes to the otherwise link.

What exact message do you get when using it as a lookup or as merge?

Instead of answering the question, I would like to point out that at Version 8 the transform stage has a surrogate key function that works quite well.

No, only rows that don't go down any other links will go down an "Otherwise".