I have script component to refresh 10 materialized views in data services job (BODS) and views created in Oracle but I have to migrate to Informatica job.
How can I create from Informatica Power Center designer?
Please specify the steps as I am new to Informatica.
All you need is a PostSQL statement added to a flow that updates the underlying data.
If you need is a separate process that triggers the refresh, just create a dummy session (with select 1 from dual where 1=2 as SQL Override) with PostSQL command to refresh the materialized views.
You can make the session a bit more robust by using parameters that will make it possible to adjust the list of views to be refreshed.