Could you please help me for the below issue.
I've a parallel job to update a netezza table .
Purpose:
Code: Select all
update xtable set c1=inputc1, c2=inputc2
where k1=inputk1 and k2=inputk2 and c3 is null
Code: Select all
update xtable set c1=orchestrate.c1,c2=orchestrate.c2
where k1=orchestrate.k1 and k2=orchestrate.k2 and c3 is null
If I use ODBC stage and gave same query, then working fine, but running very slow. So, I want to use netezza stage and need the required output. Please advice.
Thanks,