Attached in the example I want to achieve through flowheater.
I have one source adapter left hand side.
I have to tranasctiondata adapter at right hand side(RHS) where data need to be transferred from left hand side(LHS)
I have to read the createdby user which is an ID from LHS and need to map it with the UserData ID and then get the CODE and set it to Created_by_code in the RHS
In the SQL Heater you can now use this parameter as placeholder in the database lookup SQL statement, for example.
select CODE from USERDATA where ID = $ID$
Note: In the statement you have to surround the parameter name with the dollar sign!
This SQL statement will be executed for each row. The values are dynamically replaced with the value of the given parameter.
The output of the SQL Heater will be the result of this SQL statement and should connected with your “CREATED_BY_CODE” field on the WRITE side, that´s all.
Important: In case the field “CODE” is a nummeric value you have to apply a format setting to the parameter without group sepeaator! (Menu->Edit->Parameter).
I´ve made a brief example, please have look to the attachment.
1.I am trying to migrate the data from read side table to write side transactiondata table.
2.read side table having created_by id field, which need to maped with write saide user data table id, and based on that id the code need to select and write it back to transactiondata table to complete the table data migration
this scenario I am looking for to achieve from above. please let me know. thanks
Sorry, I don´t understand your purpose. I guess you wont insert or update anything in the second adapter on WRITE side?
I suppose you just want to retrive the content of the CODE field with the given ID from the
(READ side) and store it in the “CREATED_BY_CODE” field from the first WRITE adapter, is this right?
If yes, the example above should work for you, please try it.
If this assumption wrong please descripe a bit more in detail wich data you want to insert/update in the first and second adapter on WRITE side, Thanks.
Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.