How to populate and then then query a staging table in a Business Service
Hi,
Newbie Question.
I have a Staging table i want to populate by running a Stored Procedure and then query the same table with some sort of SQL inbound Adapter.
is this possible or do i need to create a separate service for this?
Thanks
Hi Yakov
First, I wouldn't implement this kind of logic in a business service. I would have a business service that immediately passes a message to a business operation and then perform these functions there (or possibly in business operations). Services should not be long-running which building and querying a staging table seems like it might take some time.