Skip to Content
Former Member
Jun 14, 2016 at 10:29 AM

Bypass the empty table during the inner join



Currently, we are facing an issue that when we join the table(TEMP_DUP_RECD) which has been populated by the previous dataflow and if contains rows then fine else empty.

If Temp_Dup_Recd table contains record then the next dataflow table named as TEMP_STAGING_TABLE making an inner join with the TEMP_DUP_RECD table to exclude these records and populating the final table(TEMP_FINAL_TABLE).

If Temp_Dup_Recd table is empty then the final table is also populated empty. We don't want the final table empty and need records which are in TEMP_STAGING_TABLE if no duplicate records are found in TEMP_DUP_RECD table

How the above scenario can be implemented?