Skip navigation
Contact Us
3836 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

    from

Atable, Btable

where

Acolumn2=Bcolumn2

and

Acolumn1=Bcolumn1

 

 

This is how i started developing the code

 

step1:

          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

 

step2

               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)

Legend

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