Forums - Execute informatica repository sql from informatica workflow

1 post / 0 new
or Register
Execute informatica repository sql from informatica workflow
prabakarreddy440
Join Date: 31 Oct 20
Posts: 2
Posted: Wed, 2020-11-11 06:50
Top

I am new to Informatica. I am using Informatica 10.1.0 and I have created a workflow

How can I make this workflow to execute the below informatica repository sql and fail the workflow is the count is greater than 0

select count(*) as cnt 

from REP_TASK_INST_RUN
where workflow_run_id = (select max(workflow_run_id) from OPB_WFLOW_RUN where WORKFLOW_NAME = 'wf_Load_Customer_Transactions')
and RUN_STATUS_CODE <> 0
  • Up0
  • Down0

Opinions expressed in the content posted here are the personal opinions of the original authors, and do not necessarily reflect those of Qualcomm Incorporated or its subsidiaries (“Qualcomm”). The content is provided for informational purposes only and is not meant to be an endorsement or representation by Qualcomm or any other party. This site may also provide links or references to non-Qualcomm sites and resources. Qualcomm makes no representations, warranties, or other commitments whatsoever about any non-Qualcomm sites or third-party resources that may be referenced, accessible from, or linked to this site.