DSXchange

I vaguely remember the post you are mentioning. Can you kindly provide me the link to that post so that i can refresh my memory and help you.

tell me this, when you say "and duplicates doesnt exist" in your logical code, what do you exactly mean by that, does that mean that the count(B.key) = 1 only ?

Cant you export the table to a csv file or a tab delimited file like in access?
Check out this post to export a foxpro table to a text file

Maybe write your own job control

When you say duplicates should not exist, do you mean completely identical records? If yes then pass both the files through the hashed files. That will take care of identical records. Create those hashed file "in the project account". Access the hashed files with the universe stage and do a sql join...

I dont think there is any evidence, because i was thinking about Array size in my head and saying Transaction size. Its actually the Array size that absolutely has to be set to 1 in "insert/update" or "update/insert" sql action, and if set higher, DS will set it to 1 during runtime. I stand corrected

Amar_nath wrote:QUESTION::
Now that instances work fine in Job Sequence but i m putting them in parallel (no link in between)

Yea, kinda missed that part.
Look at the source code that it generates. You will see that it does get fired in parallel (maybe a slight difference that is negligible).

Even i was under that impression, as thats how the DRS stage works. Well, guess the OCI stage works differently.

It will be loaded in the order that you have specified in the transformer (link ordering). But the order of load will be per record following a round robin mechanism. It might seem on the canvas that one is getting loaded before the other, but that is really not the case.

Over the command line, you cannot compile, just reset the job.

SETFILE is basically use to create a VOC pointer for that particular file in the project. Its like an alias for a file. Its used to access out of account hashed files. eg: SETFILE /my/hashed/file/myhashedfile accessible now you can import metadata for "myhashedfile" by importing the file "accessible...

Hi Linkname.coulmnname =0 OR Linkname.coulmnname =0 Or Linkname.coulmnname =0 That will not handle nulls. If you want to filter out the null values you need something like ISNULL(Linkname.coulmnname1) = 0 OR LEN(trim(Linkname.coulmnname1)) <> 0 AND ISNULL(Linkname.coulmn...

You can set the number of days limit in the director after which it will purge the log files. Other than the director, there is a job present at ADN which clears all the log files. You might want to take a look at that. Is there anything specific you are doing which is rendering your file disk space...

Thats called a wink with a touch of sarcasm in it, Right Craig!

As loveojha2 mentioned, use job parameters. But you need to set the values of job parameters from outside the job. So you need either a script or a control job to do that. Search the website for relative examples as this has been covered a lot here.
Regards,