DSXchange

Thanks all for your inputs. I have forwarded your suggestions to the team. I would update you with their decision. Previously how we planned was: We didnt want to reload the Hash file in each run. We wanted to update reload the Hash file only if the Lookup table has new row in it. We planned to writ...

ray.wurlod wrote:If you used Entire when loading Lookup File Sets, then you must specify Entire when using them. Or (Auto). Or get the warning.

Thanks a lot Ray...we decided to use message handler for that.....

DO you think it is a good decision??

The referenced hash file can be updated in the same job with the same transformer. Don't forget to check "Preload file to memory" -> Enabled for the reference and "Allow stage write cache" for the output. Hi emma, In that case the job may look something like below, with the prop...

Insufficient information. What is your source? How are these data partitioned? Clearly a Sequential File stage (which operates in sequential mode) can not preserve partitioning. You should not be expecting it to. Exactly why the Lookup stage is choosing to override your "preserve partitioning&...

Hi All, Thanks Ray for ur reponse but how to find out illegal mark characters in the fields.... Any ideas... Thank you Hi You can use this in the before routine (ExecSH) tr -d '\0' < /home/mukherav/ESA_050.txt > /home/mukherav/ESA_test1.txt This would delete all the illegal mark characters. But you...

Hi I am getting the following warnings 1) SEQL_Tgt_User: When checking operator: A sequential operator cannot preserve the partitioning of the parallel data set on input port 0. 2) LKP_Master_1: When checking operator: Operator of type "APT_LUTCreateOp": will partition despite the preserve...

Needed small clarification on Hash Load . :) We have a look up to be used while loading data to the target table. The look up has to be updated automatically whenever the table is updated. i.e. the lookup should be dynamic. We have created one table for look up (eg SETID lookup) and inserted one ro...