I am doing a migration from an existing Informatica Powercenter code to BigQuery where I ran into a scenario where a value of a column is being derived from another derived column in the same Informatica expression
Informatica Scenario:
v_abc = iif(i_SNo = 1, 1, v_mnb + 1)
o_abc = v_abc
v_mnb = iif(isnull(i_poi),v_mnb,v_abc)
where i_SNo and i_poi are the input and o_abc is the output flowing to target.
I tried to use update/merge statement by self joining (with previous instance) the table but BQ does bulk update instead of row by row. Need help in resolving the below cyclic increment/Variable handling
