Forum Discussion

rpc1235x's avatar
rpc1235x
New Contributor II
2 years ago

Filter nested object based on NULL/EMPTY or not

Hello, I have a nested JSON object that I want to divide in two streams. Filtering based on if "account-allocations" is NULL/EMPTY or not. Both streams coming from the same pipeline and eventually m...
mdawlekar's avatar
mdawlekar
Employee
2 years ago
Copy Link

Yes rriley99  you can pass the DB connection details like DB Name and other details as parameterize properties while running the pipeline.

  • Szymon's avatar
    Szymon
    New Contributor II
    5 years ago
    Copy Link

    Igor,
    thank you again. I have the .exe now and it seems like the setup you mentioned works.
    You need to set 0(zero) in max. error count for that to work. Docs says nothing about it.

    Now i will test it witl large batches.

    cheers
    Simon

    PS. In INSERT mode, it says - table not empty, even if table is empty, but i will do another post about it.

  • igormicev's avatar
    igormicev
    Contributor
    5 years ago
    Copy Link

    Hi @Szymon,

    1. The harder way:
      If it’s literally 10, 20, or even 100s of rows you can dynamically build an INSERT INTO … VALUES()… pl/sql string and execute it with the Oracle - Execute snap. But if it’s thousands oF rows or even more, then you can store the temporary data into a temp table and then apply the BEGIN … COMMIT/ROLLBACK again with an Oracle - Execute snap.

    2. The easier way 🙂
      But, maybe you’re seeking this option in a snap (Oracle - Bulk Load):

    /Igor

    • Szymon's avatar
      Szymon
      New Contributor II
      5 years ago
      Copy Link

      Thank you Igor.

      1. yes, thought of that, but i would like to avoid execute snap, since this is just a kind of error prone, if i need to build insert statements manually.
      2. saw this option too, right now the sqlldr does not work properly, so cannot say, if that is an option.
        Again, thank you very much for confirming the options.
        I almost thought i might have missed some useful feature 😆
        cheers
        Simon
  • Raviteja's avatar
    Raviteja
    New Contributor
    2 years ago
    Copy Link

    Hi,

    I'm trying to use oracle bulk insert. In the snap I see SQLLDR setting. what does that mean where should I get that exe file? Could anyone help on this?