Skip to Main Content

Marketplace

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

BluShadow Jan 3 2025

Eloqua forums are hosted over on the Cloud Customer Connect community, rather than this Developer Comunity where you have posted…

https://community.oracle.com/customerconnect/

If you're not already registered on Cloud Customer Connect you'll need to sign up (it's free) and when joining, specify what categories you are in interested in participating in.

1 - 1

Post Details

Added on Nov 30 2023
0 comments
317 views