look up join

srinu

• September 05, 2007 00:00

• Answered

Follow

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

• 

  avackova

  • September 06, 2007 13:06

  0

  Comment actions Permalink

  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
• 

  srinu

  • September 18, 2007 06:01

  0

  Comment actions Permalink

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

Please sign in to leave a comment.