Forum Discussion

sponnada's avatar
sponnada
New Contributor
9 years ago

Oracle Execute Snap Behavior when no data returned for a SQL Query

Hi All,

While we are using Oracle Execute snap, we are unable to propagate ports / column names to next snaps like mapper where there is no data in source table which is resulting pipeline failure since column names are not propagated. To mitigate this issue, we are adding always a union query to pull a dummy record to get at least 1 record from query. Is there any easy way or setting we need to do as every time we have to add this dummy record in SQL Query and need to add filter to eliminate to avoid data loads into target table.

Regards,
Srini Ponnada