DSXchange

Again , did you try using a hashed file as a tgt lookup and filtering out the rows which are found in the hashed file? If you do not have key columsn u can mark all of them as keys or can use something like a CRC logic.

Did you try increasing the scale and test it?

If I understood this correctly then i think you can compare all the columns in the file with a target table Hashed file(which can be in line or populated when the load ran last time) and determine whether it is already in the target table or not. If the number of columns are many then you can use fu...

Nope , you will have to use less than and greater than logical operator to achieve it.

Thank you !! It worked , Had to remove the inverted commas as well (i think the reason for that was becoz the parameter types were not strings. Not quite sure , but now its working.

I m trying to run a job from command line using dsjob. The job requires two parameters as input and the type of those two parameters are Path and List. Is there a way to pass values to these two in command line ? Right now my command looks like -- dsjob -server <server_name> -run -param 'param1' = '...

Work Around = Shifted the processing to the previous stage and now the variable is working fine.

Yes, I have faced this issues and tried several methods to fix it but nothing worked. the only work around that I can suggest (which worked for me) was to change the "stage" where you are using this variable - what i mean is move it to a previous stage or next stage but try to remove it fr...

Sorry if the post offended in any way....

The Hashed file which are created during the jobs. These Hashed file are located in the default directory. Any way to back them up??

Please refer to - http://dsxchange.com/viewtopic.php?t=99895&sid=11255ba02f26705a9daebd21b8b62429 Chulett , When you say "The other way is a 'normal' filesystem level backup so that the full DS installation and things like your hashed files are backed up as well" do you mean a simple c...

Check yes for the export Executables and the jobs will be exported in compiled state,,

Chullete , When you say "The other way is a 'normal' filesystem level backup so that the full DS installation and things like your hashed files are backed up as well" do you mean a simple copy paste in come other place?? Will this make sure that the hash file are intact? Also if I create a...

As far as I know your delimiter (in the merge stage) is not compatible with ur input data. Try using Pipe first and then when it works we can later replace it with comma, Also check whther ur input data has quotes in it. If yes then I am not sure how the Merge stage will handle that kind of data. Gu...

Simple thing to do will be to try to insert this record in a Sequential File and then view data in it. I am pretty sure you will catch the problem then and there itself.

Can you provide me some links...I will try to search as well.. THanks..