DSXchange

As posted, I've already handled all of the warnings and the job runs completely clean right now. I just wanted to get a better idea of what was going on and why I needed to jump though hoops to make it happy. I'll try changing Allow Null Output to True and see how that affects what I have to do down...

I don't recall 8i having TIMESTAMP data types but that doesn't change the answer - no, not that I'm aware of.

Your expectations are faulty. That's the way an outer join works, full or otherwise. Any data from the 'missing' side - key fields and all - will be null.

Take both.

One con is that sequence use in the insert statement requires user-defined sql. It also cannot be used in that manner if you need to know what the sequence will be ahead of time for RI purposes - you'd need to do a lookup of some sort and go across the network for every record processed, it seems to...

Such as? All I've done is set the Nullable attribute on the Columns tab to 'No' at first for all fields (later changed to 'Yes' as noted) and I see the default stage property of 'Allow Null Output' is set to 'False'. I don't see what else I can do there.

If you need to change parameter values between runs or after one job finishes and the next starts, you shouldn't be using environment variables.

Playing some aggregator games today and had some interesting issues, probably old news to many here but new to me (not having done much PX aggregation yet) and thought I would share. Needed to group by one field, sum three others and generate a count for each group. Is the output from calculation fi...

Metadata mismatch. You need to look at those 280 records and see what it doesn't like about them, what data does not match the metadata in the stage.

Metadata mismatch.

Well.. unless they're planning ahead.

What stage are you using? What does the documentation for that stage list as unsupported data types and/or as 'issues' for the stage? ... I'm using 'SQLServer Enterprise' Stage for extracting the records. Documentation for this stage doesn't give any information about the unsupported data types. Yo...

" u'r "? Seriously?

Neither the word I suspect you meant - your - nor the ancient Sumerian city of Ur have an apostrophe in them.

Yes, shown like that those are as you've labeled them. From the docs: Record delimiter. Specify a single character to be written at the end of each record. Type a character or select one of the following: UNIX Newline (the default) or null Final delimiter. Specify a single character to be written af...

Conversation started here but not sure that question has been answered.

viewtopic.php?p=347899

And just to beat our poor little horsey one last time, the whole point of using those project level environment variables is so that you never need to explicitly set them to a value when launching the job. They will automatically pick up the value from the environment (hence the name) and so the onu...