topic Re: tMap lookup issue in Talend Studio

tMap lookup issue

Anonymous — Sat, 16 Nov 2024 04:22:26 GMT

Tables :

Category_tbl : categoryid(Auto Generated), CategoryName, CategoryCode

Product_tbl : productid(Auto Generated),categoryid,productname

Category XLS : CategoryCode,CategoryName

Product XLS : Product Name,CategoryCode

My Process

Read Catgegory XLS -> Write Category TBL -> Read Product XLS -> JOIN tables using tMap(CategoryCode) -> Get categoryId from Lookup tbl -> Write Product with CategoryId(Foreign Key)

I Can't get the CategoryId from Lookup db connection(category tbl) component

Re: tMap lookup issue

Anonymous — Wed, 16 Oct 2019 06:23:03 GMT

Hi
Is it an inner join or left outer join on tMap? Can't get the categoryid even though the same CategoryCode exists in both tables? It might be an execution order issue, can you share a screenshot of the job?

Regards
Shong

Re: tMap lookup issue

Anonymous — Wed, 16 Oct 2019 09:23:25 GMT

The categoryid is generated by database rather than coming from Category XLS, so you need to query the categoryid after you insert the category information into database, try to change the job to
Read Catgegory XLS -> Write Category TBL
|onsubjobok
Read Product XLS -> JOIN tables using tMap(CategoryCode) -> lookup (select categoryid, CategoryCode from lookup_table)

Re: tMap lookup issue

Anonymous — Wed, 16 Oct 2019 10:22:55 GMT

Hi shong, Thanks for your promptly response,

Write Category TBL is tDBOutput(mySQL) component , Can't get onsubjobok event

Re: tMap lookup issue

Anonymous — Wed, 16 Oct 2019 11:28:37 GMT

Hi shong, Thanks for your support, It works now.