Is it possible to create one pipeline that either loads data into table or into stored procedure based on a condition of a specific field?
For example, if record_type =x use load table option else use stored procedure option?
Thanks
Is it possible to create one pipeline that either loads data into table or into stored procedure based on a condition of a specific field?
For example, if record_type =x use load table option else use stored procedure option?
Thanks
You can create two pipelines and add a WHERE clause to each. One is record_type = x and the other is record_type != x