Srinivas

• Aug 10th, 2006

 

Write a override sql query. Adjust the ports as per the sql query.

calltomadhu

 Profile Answers by calltomadhu 

• Sep 23rd, 2006

 

no it is not possible to create single lookup on multiple tables. beacuse lookup is created upon target table.

swati

• Sep 26th, 2006

 

for connected lkp transformation1>create the lkp transformation.2>go for skip.3>manually enter the ports name that u want to lookup.4>connect with the i/p port from src table.5>give the condition6>go for generate sql then modify according to u'r requirement validateit will work....

srinivas vadlakonda

• Oct 11th, 2006

 

just we can create the view by using two table then we can take that view as lookup table

Informatica_buddy

• Nov 10th, 2006

 

If you want single lookup values to be used in multiple target tables this can be done !!!

For this we can  use Unconnected lookup and can collect the values from source table in any target table depending upon the business rule ...