DSXchange

What is the issue that you are facing ... What is the volume of incoming records vs lookup table size? How long is the execution time?

I believe that this may be achieved using ISD. Are you getting parms for the data lookup also from webservice?

Thanks. Appreciate your response. We are not able to find an option to perform joins other than Inner Join in FastTrack. A way around this might be to subsequently edit the job In Designer. Unfortunately after updating the generated job in Designer, ther seems to be no good way to maintain the job i...

We need help with creating Joins in Fast Track. Can you please advise: 1. We are trying to create a Right Outer join using FastTrack, but are not able to find an option for this. Is it possible to create joins other than Inner Join in FastTrack is possible? 2. In case of three table join with matchi...

qutesanju wrote:do you mean like this?

Code: Select all

if       lnk_lkp_filter_table_xfmr.C_ACH_DIR = 'IN' then  lnk_lkp_filter_table_xfmr.N_AC2 

else  lnk_lkp_filter_table_xfmr.C_ACH_DIR = 'OUT' then lnk_lkp_filter_table_xfmr.N_AC1 

else setNULL()

Yes.

This works ...

if lnk_xfmr.DIR = 'IN' then lnk_xfmr.AC1 else
if lnk_xfmr.DIR = 'OUT' then lnk_xfmr.AC2 else ...

Note: If no default exists for "..." then use setNull().