Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am using talend tool since last month, i have got a below scenario .
I have a Serial master contains unique id for the Serial and Another Doc Master where Docid is stored against the serial unique id .
My logic is
1. Fetch the docid and Serial from transaction.
2. Map with the Serial master and fetch the Unique Id, matched one need to insert into Doc Master along with uniqueID (I dont have any problem with this ) if not available create it and then insert (Here i am facing the issue ) into Doc master .
After the creation of unique ids of new Serials ,how can i get the doc ID, do i need to MAP one more time to fetch the Doc ids for the new serials . Or another component help me to achieve this .
Currently i am using tMap to get the available and not - available Unique Ids and then insert.
Below are the Job , here i am using 2 Mapper, which will scan my table twice .So is there any alternative solution for this.
Please show a screenshot of the map editor of your tMap_1 and tMap_2.