Look up join

CloverDX Platform
1

hi

I was trying to use look up join compenent to join two tables

stg_loan—>main table

customer—>lookup table

i need to select 4 columns from stg_loan and 3 columns from customer based on loan_id.

but how should i select fields coming from lookup table into output stream as there is no provision of mapping look up table fields to output stream

and also exlpain in wat scenario we use left outer join and full outer join

Please some body help me on this.

Thanks in advance

2

Hi,
in LookupJoin component data from lookup table as treated as 1st input (0th input is data from input port). See example http://wiki.clovergui.net/examples/graphLookupJoin.grf

3

hi ,

i wrote a java progarm in the transfrom class and now it is running fine .

thanks