Infa OCI

Version 1

    Introduction

    InfaOCI is a utility which inserts data from a Flat File into a Relational Oracle target. It is an application to test OCI calls made by Informatica. This uses Oracle Native Driver Calls - OCI to perform writes into an Oracle Database.

    Purpose

    Use this utility to troubleshoot Informatica Writer issues into an Oracle Database.

    Prerequisites

    • Oracle client should be installed in the system.
    • ORACLE_HOME environment variable should be set pointing to the Oracle client installation path.

    License Info

    • Free Download

    Current Version

    • InfaOCI 1.0

    Download

    • infaoci_aix32.zip (See Attachment section below)
    • infaoci_aix64.zip (See Attachment section below)
    • infaoci_hpux32.zip (See Attachment section below)
    • infaoci_hpux64.zip (See Attachment section below)
    • infaoci_linux32.zip (See Attachment section below)
    • infaoci_solaris32.zip (See Attachment section below)
    • infaoci_solaris64.zip (See Attachment section below)
    • infaoci_windows.zip (See Attachment section below)
    • Sample input file (See Attachment section below)

     

    How to Install

    Syntax

    infaoci_xxx -connect <DBConnect_String> -i <Input_FlatFile> [-o <Output_logfile> -bufsize <buffer_block_size> -mode <Normal> -commit <commit_interval> -delimit <delimiter_character for FlatFile>]

    where
    • -connect DBConnect String Example: scott/tiger@oracle10g.world
    • -i         input file
    • -o         logfile
    • -bufsize   buffer block size : For 128KB , just enter 128: (Default 256)
    • -mode       Normal or Bulk : (Default is Normal Mode)
      • -commit  Commit Interval : (Default:1000)
      • -delimit   Delimiter Character : (Default is a comma)

    Example:

    ./infaoci_sol64 -connect testb/test@test.world -i CUSTOMERS.csv -o Output.log -bufsize 128 -mode Normal -commit 1000 -delimit "|"

     

    Usage Instructions

     

    1. Download the attached file corresponding to the operating system Unzip the file.
    2. Extract the file corresponding to the platform.
    3. Execute the file with the above mentioned synax.
    4. For UNIX:
      1. Transfer the file to the Unix machine using FTP (in binary mode).
      2. Change permission: chmod 777 infaoci
    5. Execute the file.

    Known Limitations

    • Executable for Linux 64 bit unavailable
    • The first line of the flat file should be the "Insert SQL Statement for table/columns" that are being inserted.

     

    More Information

     

    1. You can find this Target - Insert SQL in the session log. Copy and paste the statement as the first line of your flat file. This can be followed by the Flat File Data. A sample Flat file with a delimiter as "|" character is shown as following: INSERT INTO TEST_TARGET(COL1,COL2,COL3,COL4,COL5,COL6,COL7,COL8,COL9,COL10) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?,?, ?)column1_data|column2_data|column3_data|column4_data|column5_data|column6_data|column7_data|column8_data|column9_data|column10_data
    2. bufsize is the "buffer block size" you've used for the Session Run. If your Buffer block size for the session is 64K then use 64 for this value.
    3. Commit is the commit interval you've specified for the Session.
    4. Delimit is the delimiter character used to separate columns in the input Flat File. The delimiter should be in double quotes.
    5. If you don't specify an input file with -i option then, it looks for a input file "infaoci_ff.txt" under the executable folder.
    6. If you don't specify a output file with -o option then, it creates a output file called “infaoci_writer.log" under the executable folder.

    Release History

     

    Sl No.

    Version History

    1

    1.0

     

    Support Platforms

    • Windows
    • Linux (32-bit)
    • Solaris (32-bit and 64-bit)
    • HPUX (32-bit and 64-bit)
    • AIX (32- bit and 64-bit)