Hi there,
while passing a date parameter in stored procedure can we use live connection for current data and extract connection for historical data i.e, yesterday data. is it possible by using sql stored procedure.
Thankyou in advance.
2 answers
Hi Suresh,
On same data source you cant use live and extract simultaneously
what you can do
1) Create 1 data source for extract which is having historical data
2) add datasource for current data and you can use blending
with this way you can have current data always live
Hope this helps
Plz mark this answer as correct & helpful to close the thread
BR,
NB
