You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Integration

edited Sep 28, 2019 8:44PM in Integration 3 comments

Content

I have to update the a staging table with the values from the input file. I  have to run the following query in AIC.

UPDATE staging_table
    SET active_flag = :active_flag
       ,last_update_date = SYSDATE
       ,last_updated_by = :user_name
  WHERE target_value1 = :target_value1
    AND NVL(active_flag,'Y') <> :active_flag
    AND NVL(target_segment1, 'DEFAULT') = NVL(:x_segment1, 'DEFAULT')
    AND NVL(target_segment2, 'DEFAULT') = NVL(:x_segment2, 'DEFAULT')
    AND NVL(target_segment3, 'DEFAULT') = NVL(:x_segment3, 'DEFAULT')
    AND NVL(target_segment4, 'DEFAULT') = NVL(:x_segment4, 'DEFAULT')
    AND NVL(target_segment5, 'DEFAULT') = NVL(:x_segment5, 'DEFAULT')
    AND NVL(target_segment6, 'DEFAULT') = NVL(:x_segment6, 'DEFAULT')

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!