tMap lookup on a file based on the has value of an input field

[Anonymous]

Hi,

In a subjobA I have created a sample delimited file which has cust numA, cust nameA, cust addressA, sequence number(starts from 1), and count(total record count of this file).

In another subjobB I have a tMap whose input is from a table which has cust numB, cust nameB, and addressB. This subjob runs onSubjobOK on subjobA.

I wanted to get the (hash value of the cust nameB)% count(from subjobA) in tMap expression and lookup on the seq number(subjobA) to get cust nameA.

Finally the tMap should have cust numB, cust nameA, addressB.

Could you suggest if this can be done using tMap or I require other component.   

[Anonymous]

Hi,

     Could you please elaborate your business scenario in detailed manner. My current understanding is that you are trying to verify whether the customer data coming from the input file is already available in the database. If it is available (based on the match condition between file and DB data), you are looking for the existing customer number from the DB. If the data is not available in DB, you are trying to load the data from file to DB (after some masking).

      Is the above description a fair statement? If yes, could you please specify the current join condition between file and DB? Also would you like to pass the data directly from file to DB for new records or would you like to do some data masking for some columns?

      If you can share a screenshot of the job based on your current understanding, it will hep us to do detailed analysis.

Warm Regards,

Nikhil Thampi

[Anonymous · Accepted solution]

Thanks Nikhil. I found an alternative solution

[Anonymous]

This requirement is not valid and please close this request.