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...
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...
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...
Thanks Juergen for your reply.
I did find out that it was indeed the sql i was using in my sql override. Apparently there were some formatting issues (blank spaces etc.) since I had created the sql in word and copied and pasted it in the sql override window !
After breaking my head over it for...
Hi all
I had a running/working mapping that needed to be modified since some of the columns that were being used from the sources had been dropped and renamed or moved to another table. And thus it was necessary to make the changes to these source tables and their columns in my mapping's Source...
Here is the syntax for creating a soft link:
ln -s <directory or file you want the link to point to> <name of the link>.
For eg. if i wanted to have a link called 'java' to point to /usr/j2sdk1.2/bin/java created in the '/usr/bin' directory, I would issue the following command in the...
I had WL running on a Windows workstation. And it was working fine. It was using oracle's tnsnames.ora file.
Now we have switched to Oracle Names Server. But WL doesnt like that. How do i re-configure WL to now go to the names server.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.