Could not uniquely identify $Source - HELP !

[kg11]

I am getting the following message when running the session for one of my mappings:
TM_6190 ERROR: Could not uniquely determine connection $Source or $Target for a lookup or stored procedure transformation

I checked all lookups (they do use the session parameters $Source and $Target), and in my session properties, i have selected my source and target databases to point to the ones i have configured in Oracle's tnsnames file.

Has anyone seen this before?

Thanks in advance,
KG

 

[Dagon]

TM_6190 ERROR: Could not uniquely determine connection $Source or $Target for a lookup or stored procedure transformation.

Cause: You specified either the $Source or $Target variable in the Location Information property in a Lookup transformation. The mapping has more than one relational source or relational target database connection.

Action: Edit the properties of the Lookup transformation and enter a specific database connection.

Do you have more than one source table in your mapping ? Is there a heterogenous tab on your session properties ? If so, do you have more than one database connection defined there ?

 

[kg11]

HI Dagon
Yes, i do have >1 source databases that I am pulling my tables from. Yes, I do have a heterogeneous tab and I had defined one db connection for all my source tables there..
And i did resolve this issue by entering a specific connection (in the lookups)earlier, but i wanted to find out why $Source or $Target wouldnt work. Isnt this the ideal way to do it so that if u ever want to switch databases for testing, you could then just do it at one place (in the session properties)?

Thanks !

 

[Dagon]

Yes, but how is Informatica going to know which source you mean when you have two of them ?

Another solution is to use a parameter e.g. $DBConnection1. You can then assign the lookup connection to that and set it to the real database connection in your parameter file.

 

[kg11]

Ok, so to make sure i have this right,
Here is what I have in my session props' 'General Tab':
Source Type: Heterogeneous (greyed out)
'Source Location' tab:
Source Qualifier Source Type Source Name
SQ_CLAIM_EXT Database $Source
SQ_CLAIM_EXT1 Database $Source
SQ_CLAIM_EXT2 Database $Source

ANd here is what I have in my lookup transformations:
Location Information: $Source

This setting does not work.

When I changed the Source Location tab to the following, it worked:
Source Qualifier Source Type Source Name
SQ_CLAIM_EXT Database dwprd
SQ_CLAIM_EXT1 Database dwprd
SQ_CLAIM_EXT2 Database dwprd
Lookup still has $Source

So u r saying that since I have multiple sources, IS does not know which source to go to when it encounters the '$Source' in the Source Location tab?

But then how come it knows to go to the right source for the lookup?

Thanks!