How to view Step1-Query EXTRACTION with parsed parameters

Here is a handy piece of SQL that allows you to view your extraction query with the parameters value parsed the way it would execute in BPM Connect.

use bpmconnect
go
declare @Remote_Query varchar(8000)
exec [p_ETL_RQP] 'MyLittleFeed', 'EXTRACTION', @Remote_Query output
select @Remote_Query as Remote_Query


So for example, if you have an EXTRACTION query as such:
select * from tblfacttable where period = '?Period'
This query would substitute the ?Period value. So if the ?Period is set to '03' in the Data Process Control, the query would look like:
select * from tblfacttabel where period = '03'
This is very handy when troubleshooting extraction querys and to validate the parameter values are be passed correctly.


For remote stage type queries, you can reference the output in the ETL_RQRS table.