Forum Discussion

sshaik's avatar
sshaik
New Contributor III
3 years ago
Solved

Unique Constraint Issue in Oracle while inserting Data

In this Scenario, I have to insert data onto an Oracle DB. Before that one I’m performing a Left Outer join and separating the data (for Update and Insert) by using router. In Insert snap I have to i...
  • sshaik's avatar
    sshaik
    3 years ago

    Solved this scenario in a different way.
    Insert handled by using inner join.
    For Update
    Here I have to update 2 columns($status, $ID) based on 6 key columns matching data.
    So, I have read the target table as reference table($col_Ref) and regular/new data as left side data and performing an inner join based on 6 key columns.
    There I found the matching data.
    I put 1 filter to sort $status=“Active”
    I just mapped 2 ($status hardcoded as “INACTIVE” I have to update the $status column if $stat=“Active”, $ID taken from filter ) columns which I want to update in the Target Table.

    Finally in Oracle Update snap mentioned Schema and table name.
    In where clause $Status=“Active”.

    This was one of the ways that I found for resolving this issue.

    If we have any other ways to handle this, then it could be helpful.

dwhansen-cbg's avatar
dwhansen-cbg
Contributor
6 years ago
Copy LinkReport

For anyone wondering, I’m using a Join Snap with an Outer Join.

If a unique ID field from the left side is null but populated on the right side then it is a deleted record.
If a unique ID field from the left side is populated but null on the right side then it is a new record.
If a unique ID field from the left side and right side are both populated then the it is an existing record.

  • robin's avatar
    robin
    Former Employee
    8 years ago
    Copy LinkReport

    @matt.bostrom, JSON Generator can use upstream document expression variables, and REST POST supports specifying a field within the input document as the request body. Combining those will get what you want:

    I’ll make a note about adding pass-through support to JSON Generator.