Hi,
I am new to Streamsets.
I have a situation where i have created 3 pipelines on Transformer (Each pipeline runs 3-4 SQLs) has Business Date as a parameter (Current Date-1).
Use case - I need to trigger the first pipeline and when its completed then the second pipeline should run and when second pipeline is completed then third pipeline should be running.
I have tried creating an orchestration pipeline on Data collector using start job, created job templates for each pipeline by watching some sample video and reading the documents but unable to achieve the above use case in the orchestration pipeline.
Is there any other way to achieve this.
Can anyone please help and advise. I would be obliged for any help received.