If we use Joiner , then it is taking to much time. We have table A and Flat file B. A table has following fields Name , DEPT, SALARY. File B has following fields NAME and DEPT. We have to match the NAME in between table and file B and update DEPT field in File B on the basis of Value of DEPT present in Table A.
Table A
NAME DEPT SALARY
John WSS 10000
Micheal LSS 50000
Flat File B
NAME DEPT
JOHN
JOHN
Micheal
Micheal
Output(After Updation) Table B
NAME DEPT
JOHN WSS
JOHN WSS
Micheal LSS
Micheal LSS
first import ur flat file b as a source
then You need to use Lookup transformation on table A
drag the name column source to look up transformation and check the look up condition table A name and flat file name
name=name
then drag name and dept in expression transformation then target