top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Executing PostgreSQL function in informatica

0 votes
373 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
replace null with 0 for the returned from count(*) function of aggregator in informatica

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
How to implement Cume_Dist() analytic function logic in informatica

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
how to implement row level summmary function in informatica

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.

0 votes
Case Statements/Decode Function in Informatica

Could anyone help me with writing case statements in Informatica PowerCenter Designer? I am fairly new to Informatica, and based on my limited experience I feel case statements aren't supported. There is a decode function with similar functionality, but I am unable to find any good examples on the syntax.

I would really appreciate if anyone could give me some specific examples on how to use case statements/decode function in Informatica.

Thanks much for your help

0 votes
What the decode function do in the update flag port in informatica?

I'm new to Informatica and like to ask a question regarding infa ports. I found an example which show how to create an update flag in expression transform for updating data. The code in v_UPDATE_FLAG port looks like this:

IIF(NOT ISNULL(PREV_ITEM_KEY)
AND
(
DECODE(BONUS_FLAG,PREV_BONUS_FLAG,1,0) = 0 
OR
DECODE(DISCOUNT,PREV_DISCOUNT,1,0) = 0 
OR
DECODE(PRICE,PREV_PRICE,1,0) = 0 
),'TRUE','FALSE')

Can you explain what this does? What the DECODE does here??

DECODE(BONUS_FLAG,PREV_BONUS_FLAG,1,0) = 0
...