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 ...
sponnada's avatar
sponnada
New Contributor
9 years ago

Oracle execute is allowing us to pull data by joining more than one table to apply SQL Query level joins and filters. This way we are leveraging the dw appliances power to get changed data in a faster way so I am using Oracle execute than oracle select.

skatpally's avatar
skatpally
Former Employee
9 years ago

You can add a mapper to propagate the column names to the input view of the Oracle Execute Snap and enable the pass through button so that you will have the original object flowing from the Execute snap. You can provide an example.