Skip navigation
Contact Us
6021 Views 9 Replies Latest reply: Sep 29, 2010 10:00 AM by David Menzies RSS
Sudir Ch Newbie 12 posts since
Sep 26, 2010
Currently Being Moderated

Sep 26, 2010 12:04 PM

SourceQualifier SQL Override Error

Dear Friends,


I am a newbie to Informatica and i think i m doing something real stupid to fix it. Your help is greatly appreciated and below the scenario


I have the following query to do for my informatica mapping. In this mapping, I need the ports from Atable only, but i am comparing it with columns of the Btable(no port from Btable is used in rest of mapping).



My select statement is like this


select Acolumn1, Acolumn2,Acolumn3,Acolumn4


Atable, Btable







This is how i started developing the code



          I got two sources and sourceQualifiers for Atable and Btable and then I deleted one sourceQualifier for Btable and borrowed the ports of Btable Source to Atable SourceQualifier



               I am using SQL Override in (Atable)Source Qualifier, but this one is not working and showing the error that "port names should be in respective order"  I checked again and made sure the ports are in order


          But still now I see the same error, I am not able to fix this.


Can you suggest on this.


Tx Advance.

More Like This

  • Retrieving data ...

Bookmarked By (0)


  • Correct Answers - 10 points
  • Helpful Answers - 5 points