top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Override SQL Query and the OUTPUT PORTS

0 votes
742 views

What will happen if the SELECT list COLUMNS in the Custom override SQL Query and the OUTPUT PORTS order in SQ transformation do not match?

posted May 4, 2015 by Sachin

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

Mismatch or Changing the order of the list of selected columns to that of the connected transformation output ports may result is session failure.

answer May 5, 2015 by Shweta Singh
Similar Questions
+3 votes
Ambiguous error in Lookup Override for teradata query

I am using below self join query as Lookup override in informatica. This is running fine in teradata.

SELECT A.region_cd AS REGION_CODE, 
       A.enp_no    AS ENP_NBR, 
       B.sla_cd    AS SLA_CODE 
FROM   edb_man_work.emp A, 
       edb_man_work.emp B 
WHERE  A.company_no = Trim(Cast(B.enp_no AS INTEGER)) 
       AND A.region_cd = B.region_cd

This is running fine in teradata but while running in mapping it is giving error

as Column SLA_CD is ambiguous.

I am not sure why this is giving this type of error.

+3 votes
Source Qualifier SQL Override Error with Mapping Variables

I am using a mapping variable of date/time data-type and aggregation MAX In Source Qualifier SQL Override i am giving select col1,col2 from tbl where col1>$$dt

(col1 is also date data type)

When i am validating the query it is giving Invalid Query and error was

 [Microsoft][ODBC driver for Oracle][Oracle]ORA-00933 : SQL command not properly ended

I have also done extraction of characters like select col1,col2 from tbl where to_char(col1,'DD-MM-YY')>to_char($$dt,'DD-MM-YY') but still the same same

I am not getting what the error is and the same thing if i am trying for number column the it is validating fine and performing incremental extract also.

Any suggestions regarding the same will be helpful

+3 votes
Search Informatica for text in SQL override

Is there a way to search all the mappings, sessions, etc. in Informatica for a text string contained within a SQL override?

For example, suppose I know a certain stored procedure (SP_FOO) is being called somewhere in an INFA process, but I don't know where exactly. Somewhere I think there is a Post SQL on a source or target calling it. Could I search all the sessions for Post SQL containing SP_FOO ? (Similar to what I could do with grep with source code.)

0 votes
SQL Query in Informatica Cloud

am trying to integrate a MySQL database with Salesforce but am having trouble with part of the query logic.

I enter this query:

SELECT occupation_name FROM skillsmatch_skillsprofile GROUP BY time_updated ORDER BY time_updated DESC LIMIT 0,5

But get this error:

<> missing operator... SELECT>>>> <<<

Any idea where I might be going wrong?

Thanks for your help!

...