DSXchange

Suggest that you contact your official support provider regarding that patch and if there are any known issues related to it.

Similar? Possibly. Same? No.

Please start your own post and give us the gory details of your issue.

What "this new patch"?

If your join key columns are null on one side or the other, then you'll need to look into some flavor of a outer join. An inner join will never return any records where join keys are null. I am using a left outer join and sorry that I did not mention it earlier. You did when you said "left joi...

Does that leverage a single cache under the covers, or four?

I have no idea. Have you asked your official support provider what some workarounds might be for a 'single PC' or if in fact there are any?

How many times are you going to post this?

Again, what kind of 'date validation' do you need to do? The trailer validation is just a record count compared to the number in the trailer.

There isn't any such document although there may be anecdotal evidence from people here. CPU would fall into what Ray has called the "more is better" camp, I would imagine, much like disk and memory but I've never seen any sort of minimum or recommended CPU listed.

As in what they do does not vary, the other stages do one thing and that thing is accomplished by the OSH script they generate.

That's the SQL Builder, something you should only "need" if for some reason you can't let the stage generate the SQL for you automatically and you have no idea how to write it yourself. And it's for selecting data, not inserting it. No need for that here. At a high level - build the job li...

How many is "too many"? Should be the right tool for the right job.

Was wondering if the looping functionality in the 8.5 release might be leveraged for something like this but it's academic, it would seem.

rajadommeti wrote:You mean I have to use Cron to schedule (job_for_ever) job to run everyday at 7 a.m?

Have to? No. Just noting that you certainly could, seeing as how that's exactly what it does: run things on a regular schedule. Why reinvent the wheel?

So, do you just literally need to validate the file? What kind of date validation do you need to do? What needs to happen if the validation fails?

Formatting is for peoples, not processes - turn off the formatting and just let it stream it out. When you need to look at it, let something like Internet Explorer automagically pretty it up. If you really, really think you "need" it to look like you posted, find yourself a pretty print ut...