DSXchange

Search for the string "JOB.1305815817.DT.1340632490.TRANS1" in your DS project folder. You will hit couple of files. Please open it and check out the particular Line number 204, for more details on the phantom error.

Are you passing all required parameters to the job from the sequencer?

Just FYI. I'm working on Version 7.1r1. Encrypted parameters works fine for me.

Is ur input a file or a ODBC/DRS stage?? If the data is fetched using a SQL query in the ODBC/DRS stage then use ORDER BY DESC to get the data in the reverse order.
If your inpt is a file then I doubt if we can do it in DS.

You have to create two hash files. One with keys A and B and other with Keys A and C.

Do both the lookups unconditionally.

In your transformer use a derivation as
If C3='LINE' and Lkp1 successful then LKP1.value
else If C3='POINT" and LKP2 successful then LKP2.value

Hope this helps.

Hash Files can have composite keys. I have worked with lots of hash files with composite key. Sometime, hash file lookup doent return proper values if you do a lookup on a integer column. That necessitates to convert the integers to char field and then perform the lookup. It would have worked for y...

Currently, in all our jobs we are using a IPC stage to achieve the parallelism explicitly. But if we can turn on the project level setting to inter-process buffering, then we can avoid using IPC stage in all our jobs. By this way we can gain lot of effort involved in coding this stage in all our hun...