Skip to Main Content

Marketplace

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

ODI Inserts Lesser Rows with UNION Clause in Target ADW

Shib Seal-OracleNov 30 2023

Hi,
One of the ODI Mappings having Union Clause in the Source inline Select seems to load much less records in the Target (ADW). While the same Insert-Select is loading more rows in the ADW Target table, when the query is triggered directly from the database. In Dev, the ADW Wallet is pointed to Medium and also the ODI topology pointed to Medium

Oracle Data Integrator Studio 12c 12.2.1
Data Integrator Version 12.2.1
Build ODI_12.2.1.4.0OCIADWBP_GENERIC_230713.0437

Results of the Query Execution:
##################
-- From ADW SQL Developer (Medium) : Union ALL: 2,503,275
-- From ADW SQL Developer (Medium) : Union : 2,503,248

-- From ODI using UNION ALL : 2,327,939
-- From ODI Using UNION : 2,327,919

If any of you have faced this issue, appreciate if you respond in this post with your thoughts.

Thanks in advance!

Comments
Post Details
Added on Nov 30 2023
0 comments
39 views