Forum Stats

  • 3,826,799 Users
  • 2,260,708 Discussions
  • 7,897,074 Comments

Discussions

Knowledge Modules - when to use what?

735763
735763 Member Posts: 160
edited Nov 24, 2009 10:24AM in Data Integrator
I have a created an interface that loads data into the source Oracle DB and works absolutely fine when I execute it individually. However it does not load the data when I put it in a package, which contains interfaces that loads data into the same table.

Not sure what the issue is; and also I dont get any error during the process - It says it finished executing the package, but when I check the target table I dont see the data.

The knowledge modules I have are:
----------------------------------------------------
IKM Oracle Incremental Update
IKM SQL Control Append
IKM SQL to SQL Append

I might be doing something silly! any help is greatly appreciated.

Best Regards,

Edited by: user12242480 on 23-Nov-2009 09:55

Edited by: user12242480 on 23-Nov-2009 10:39

Answers

  • 735763
    735763 Member Posts: 160
    OOps,

    The data gets loaded without any issue when I changed the IKM selection from "IKM Oracle Incremental Update" to "IKM SQL Control Append". Not sure if that is the correct way to go.

    Is there any detailed notes available on the Knowledge Modules and about what KM strategies to use!

    Regards,
  • 735234
    735234 Member Posts: 29
    Please can someone help me to understand the difference between the below KMs:

    1. KM Oracle Incremental Update
    2. IKM SQL Control Append
    3. IKM SQL to SQL Append

    Appreciate your time.
    Thanks
This discussion has been closed.