Siebel Open UI, Tools, Scripting and EAI (MOSC)

MOSC Banner

Check for existence of a child IC in Siebel Data Map Source Search Spec

edited Dec 16, 2016 12:26AM in Siebel Open UI, Tools, Scripting and EAI (MOSC) 2 commentsAnswered

We have an external data structure that looks like this:

Parent 1

     - Parent Attrib1

     - Child 1

          - Child Attrib1

     Child 2

          - Child Attrib 2

...

In mapping the external parent to internal parent, we want a "Source Search Specification" that says:

IF [Parent Attrib 1] IS NULL AND <NO CHILD RECORDS EXIST>

Any idea how to implement "<NO CHILD RECORDS EXIST>" logic in the Siebel Data Map / Integration Map?

I've thought about the concept of "COUNT" and "EXISTS" but these don't seem to exist in the world of the Data Mapper - at least, they are not documented.

Thanks in advance!

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center