How to call a stored procedure / macros on teradata from informatica cloud?

Question

I am trying to call a macro on Teradata from Informatica cloud but I was not able to achieve any success I tried SQL transformation, it works only for SQL server and oracle but not for teradata. Anyone has any idea how to call a macro on Teradata from the Informatica cloud.

score 2 · Answer 1 · answered Mar 12 '20 at 12:08

2

You'll need to call a pre or post action the runs code on the O/S to trigger the macro. I generally use Python for pre and post actions as it is portable across O/Ss.

answered Mar 12 '20 at 12:08

Scott S Nelson

178
6

score 0 · Answer 2 · edited May 13 '20 at 12:50

0

in the post sql section of the target, you can call your stored procedure (exec spname)

edited May 13 '20 at 12:50

Jean-François Fabre

137,073
23
153
219

answered May 06 '20 at 02:03

tushar TAZz

64
3

How to call a stored procedure / macros on teradata from informatica cloud?

2 Answers2