Oracle Data Integrator 11g Knowledge Modules Description

RKM Oracle

Reverse-engineers tables, views, columns, primary keys, non unique indexes and foreign keys.

JKM Oracle 10g Consistent (Streams)

Creates the journalizing infrastructure for consistent set journalizing on Oracle 10g tables, using Oracle Streams.

JKM Oracle 11g Consistent (Streams)

Creates the journalizing infrastructure for consistent set journalizing on Oracle 11g tables, using Oracle Streams.

JKM Oracle Consistent

Creates the journalizing infrastructure for consistent set journalizing on Oracle tables using triggers.

JKM Oracle Consistent (Update Date)

Creates the journalizing infrastructure for consistent set journalizing on Oracle tables using triggers based on a Last Update Date column on the source tables.

JKM Oracle Simple

Creates the journalizing infrastructure for simple journalizing on Oracle tables using triggers.

JKM Oracle to Oracle Consistent (OGG)

Creates and manages the ODI CDC framework infrastructure when using Oracle GoldenGate for CDC. See Chapter 26, “Oracle GoldenGate” for more information.

CKM Oracle

Checks data integrity against constraints defined on an Oracle table.

LKM File to Oracle (EXTERNAL TABLE)

Loads data from a file to an Oracle staging area using the EXTERNAL TABLE SQL Command.

LKM File to Oracle (SQLLDR)

Loads data from a file to an Oracle staging area using the SQL*Loader command line utility.

LKM MSSQL to Oracle (BCP SQLLDR)

Loads data from a Microsoft SQL Server to Oracle database (staging area) using the BCP and SQL*Loader utilities.

LKM Oracle BI to Oracle (DBLINK)

Loads data from any Oracle BI physical layer to an Oracle target database using database links. See Chapter 17, “Oracle Business Intelligence Enterprise Edition” for more information.

LKM Oracle to Oracle (DBLINK)

Loads data from an Oracle source database to an Oracle staging area database using database links.

LKM Oracle to Oracle (datapump)

Loads data from an Oracle source database to an Oracle staging area database using external tables in the datapump format.

LKM SQL to Oracle

Loads data from any ANSI SQL-92 source database to an Oracle staging area.

LKM SAP BW to Oracle (SQLLDR)

Loads data from SAP BW systems to an Oracle staging using SQL*Loader utilities. See the Oracle Fusion Middleware Application Adapters Guide for Oracle Data Integrator for more information.

LKM SAP ERP to Oracle (SQLLDR)

Loads data from SAP ERP systems to an Oracle staging using SQL*Loader utilities. See the Oracle Fusion Middleware Application Adapters Guide for Oracle Data Integrator for more information.

IKM Oracle AW Incremental Update

Integrates data in an Oracle target table in incremental update mode and is able to refresh a Cube in an Analytical Workspace. See Chapter 21, “Oracle OLAP” for more information.

IKM Oracle Incremental Update

Integrates data in an Oracle target table in incremental update mode.

IKM Oracle Incremental Update (MERGE)

Integrates data in an Oracle target table in incremental update mode, using a MERGE statement.

IKM Oracle Incremental Update (PL SQL)

Integrates data in an Oracle target table in incremental update mode using PL/SQL.

IKM Oracle Multi Table Insert

Integrates data from one source into one or many Oracle target tables in append mode, using a multi-table insert statement (MTI).

IKM Oracle Slowly Changing Dimension

Integrates data in an Oracle target table used as a Type II Slowly Changing Dimension.

IKM Oracle Spatial Incremental Update

Integrates data into an Oracle (9i or above) target table in incremental update mode using the MERGE DML statement. This module supports the SDO_GEOMETRY datatype.

IKM Oracle to Oracle Control Append (DBLINK)

Integrates data from one Oracle instance into an Oracle target table on another Oracle instance in control append mode.

This IKM is typically used for ETL configurations: source and target tables are on different Oracle instances and the interface’s staging area is set to the logical schema of the source tables or a third schema.

SKM Oracle

Generates data access Web services for Oracle databases. See “Working with Data Services” in the Oracle Fusion Middleware Developer’s Guide for Oracle Data Integrator for information about how to use this SKM.

Advertisements

About Amit Sharma

BISP Solutions Inc. was founded in 2012 as a IT consulting and service provider, specializing in Oracle EPM/BI technologies. Our primary objective is to use our expertise to offer best EPM/BI solution and being cost effective. In a relatively short period of time, we have successfully become an information technology company having a long list of clients in North America. BISP Solutions has been providing solutions to unique customer requirements and has a proven track record and ability to deliver high end business EPM solutions that meet your business goals. BISP Solutions EPM solutions have helped various customers in EPM space and earning a reputation of consistently exceeding our customer expectations. We bring tremendous value to our customers due to ability to replicate with ease, deploy at a faster pace in a very flexible global delivery model with lowered costs. Our ultimate goal is to save time and money of our business partners by delivering a highest quality of solution/services. We believe that working closely with customer and having detailed understanding of the business domain is the key to success. Our iterative methodology has proven to be very successful in this regard. Our experts are Oracle certified and committed to specializing in EPM and BI services, providing the highest flexibility while designing your EPM solutions. BISP business methodology is based on 5C’s. 1. Commitment - As a wise man once said, “Commitment is what transforms a promise into reality”. We are committed in providing the best possible solution to you. 2. Collaboration - We collaborate and communicate with you to understand your business requirements and using our collective knowledge to provide a solution that not only follows cutting edge technology and best practices but is also simple to use. 3. Consistent - We guarantee our solutions and have been consistent in delivering cost effective solutions to our business partners. 4. Cost Effective – This is where we shine. We provide solutions that while being cutting edge are also financially feasible. Our Onsite / Offsite (consultants based in US) model provides the best in technology solution while keeping the cost significantly low of what leading consulting companies charge. 5. Customized – While we can implement out of the box solutions, we strive to provide a solution that works for you.
This entry was posted in Uncategorized. Bookmark the permalink.

One Response to Oracle Data Integrator 11g Knowledge Modules Description

  1. Kandice says:

    When you’re going to rent a comic, think about these
    tips as a useful guide, pointing in the fitting direction.
    Think of this as a way to document your improvements over time, and eventually it
    will be a very effective PR tool. These surgeries are a matter of personal
    preference, peer pressure from fellow entertainers and the need to maintain an unrealistic image that is associated
    with them.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s