top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration

Facebook Login
Site Registration

Executing PostgreSQL function in informatica

0 votes
147 views

I'm using informatica desinger and postgres DB and i'm trying to execute a sql function that i created in sql. I tried to connect them with "sql transform" but i get the following error:

"invalid function agruments", but since I use constants I'm positive that i got them on the right order (i ran the function successfully in postgres)

posted Nov 3, 2014 by Amit Sharma

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

1 Answer

0 votes

there could be the error with the comments passed in transformation. You need to make sure function name mentioned is correctly spelled

answer Nov 6, 2014 by Shweta Singh
Similar Questions
0 votes

I am using aggregator transformation in my Informatica mapping where I am counting number of records coming from sql override.I need to pass zero value to target table as counts in case if I get 0 number of return counts from count(*) function of Aggregator Transformation.

+1 vote

Pl help me here to implement CUME_DIST() logic in informatica. My requirement follows.

CUME_DIST ( ) OVER ( PARTITION BY completionmonth, product_industry_desc, dsa_region ORDER by LT_AVG_$$ desc)*100

My manager doesn't want sq override. We need to implement same in informatica with expression/Agrregator like.

Pl help how to and what that mean?

Thanks

0 votes

Can someone please explain me how to implement the following logic in informatica. but Not with source qualifier with other transformations inside the mapping.

SUM(WIN_30_DUR) OVER(PARTITION BY AGENT_MASTER_ID ORDER BY ROW_DT ROWS BETWEEN 30 PRECEDING AND 1 PRECEDING)

Basically this is sql(oracle) level requirement but i want at informatica level.

Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...