reddeppa

• Jan 5th, 2006

 

why using SQL override..we can lookup the Data on multiple tables.See in the properties..tab..

Srinu

• Jan 6th, 2006

 

 Hi,

  Thanks for your responce. But my question is

   I have two sources or target tables i want to lookup that two sources or target tables. How can i. It is possible to SQL Override.

sachin

• Jan 9th, 2006

 

just check with import option

sankar

• Jan 9th, 2006

 

How to lookup the data on multiple tabels.

gazulas

 Profile Answers by gazulas Questions by gazulas

• Jan 29th, 2006

 

if u want to lookup data on multiple tables at a time u can do one thing join the tables which u want then lookup that joined table. informatica provieds lookup on joined tables, hats off  to informatica.

Vibha

• Feb 9th, 2006

 

Hi ,

You can do it.

When you create lookup transformation that time INFA asks for table name so you can choose either source, target , import and skip.

So click skip and the use the sql overide property in properties tab to join two table for lookup.

rajendar

• Feb 11th, 2006

 

join the two source by using the joiner transformation and then apply a look up on the resaulting table

prasadns26

 Profile Answers by prasadns26 

• Jul 18th, 2006

 

hi,

what ever my friends have answered earlier is correct. to be more specific,

if the two tables are relational, then u can use the SQL lookup over ride option to join the two tables in the lookup properties.u cannot join a flat file and a relatioanl table.

eg: lookup default query will be select lookup table column_names from lookup_table. u can now continue this query. add column_names of the 2nd table with the qualifier, and a where clause. if u want to use a order by then use -- at the end of the order by.

hope this is more clear