2 Replies Latest reply on Nov 12, 2019 4:00 PM by 842395

Post SQL informatica equivalent in ODI

c0aa0d43-2fdf-452a-8786-08e8e3b2fabe Nov 9, 2019 4:15 AM

I have recently started on a project with ODI after years of experience in working on Informatica. I have an update query which I need to execute once a mapping has been completed. With informatica I could do it with 'Post SQL' option in the session properties, but I cannot find an equivalent option in ODI.

Your help is appreciated. Thanks,

1. Re: Post SQL informatica equivalent in ODI

Adrian_Popescu-Oracle Nov 9, 2019 7:45 PM (in response to c0aa0d43-2fdf-452a-8786-08e8e3b2fabe)

Hi,
ODI 12c has a similar functionality - it is called "End mapping Command".
See it at the bottom of this screen-shot:

On ODI 11g you could use an ODI procedure to execute that SQL.
And add the interface and the procedure in an ODI package.

Adrian
Like Show 0 Likes(0)

Actions
2. Re: Post SQL informatica equivalent in ODI

842395 Nov 12, 2019 4:00 PM (in response to c0aa0d43-2fdf-452a-8786-08e8e3b2fabe)

in odi 12c first create the mapping and next create the procedure.now both put in one package on sequence order mapping---(ok)--->procedure.
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.