How to join two tables in informatica without using JOINER transformation?

1.8k views Asked by At

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
2

There are 2 answers

0
jack On

first import ur flat file b as a source

Flat File B
NAME   DEPT
JOHN     
JOHN   
Micheal
Micheal

then You need to use Lookup transformation on table A

Table A
NAME    DEPT   SALARY
John    WSS    10000 
Micheal LSS    50000

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

0
Lev On

There is some ways to improve the performance in your case:

  1. In case both of your tables are located in same data base, you have to implement your join inside Source Qualifier. It's a most effective way.

  2. In case you want to use joiner transformation, you have verify, that the smallest input (smallest table) is marked as Master. It's also worth to sort the input and check "Sorted Input" option in your joiner transformation.