Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange for Teradata Parallel Transporter API
  3. PowerExchange for Teradata Parallel Transporter API Configuration
  4. PowerExchange for Teradata Parallel Transporter Connections
  5. PowerExchange for Teradata Parallel Transporter API Data Objects
  6. PowerExchange for Teradata Parallel Transporter API Mappings
  7. Teradata Parallel Transporter API Run-time Processing
  8. Data Type Reference

PowerExchange for Teradata Parallel Transporter API User Guide

PowerExchange for Teradata Parallel Transporter API User Guide

Configuring the InfaTDCHConfig.txt File

Configuring the InfaTDCHConfig.txt File

Configure the
InfaTDCHConfig.txt
file to define the parameters that TDCH must use to read and write data when you run a Teradata mapping on the Hive engine. Informatica ships a sample
InfaTDCHConfig.txt
file. Customize the sample file based on your requirements.
  1. Access the following directory:
    <Informatica installation directory>\services\shared\hadoop\<Hadoop_Distribution_Directory>\infaConf
  2. Find the file named
    InfaTDCHConfig.txt
    .
    Back up the file before you modify it.
    If the
    InfaTDCHConfig.txt
    file is missing from the
    <Informatica installation directory>\services\shared\hadoop\biginsights_3.0.0.1\infaConf
    directory, you must manually copy the file from another Hadoop distribution directory.
  3. Use a text editor to open the file and edit the properties.
  4. Set the libjars parameter to the paths that contain the dependent jars required for TDCH. Perform the following tasks:
    1. To get the list of dependent jars required to run a TDCH job, open the readme file from the following location:
      /usr/lib/tdch/1.5
    2. Under
      Dependencies
      , view the
      Hive Job
      section to find the list of jar names.
    3. Locate the jars on the Hadoop nodes in the following directory:
      hive/lib
      .
      For example: On the Cloudera nodes, verify if the jars are available in the following directory:
      /opt/cloudera/parcels/CDH-5.8.4-1.cdh5.8.4.p0.5/lib/hive/lib/
      Ensure that all the jars are available even though the version of the readme and the jar file might differ.
    4. Add all the jars along with the PATH to the libjars variable in the
      InfaTDCHConfig.txt
      file.
      For example:
      libjars=/opt/cloudera/parcels/CDH/lib/hive/lib/libthrift-0.9.3.jar, /opt/cloudera/parcels/CDH/lib/hive/lib/commons-pool-1.5.4.jar, /opt/cloudera/parcels/CDH/lib/hive/lib/commons-dbcp-1.4.jar, /opt/cloudera/parcels/CDH/lib/hive/lib/libfb303-0.9.3.jar, /opt/cloudera/parcels/CDH/lib/hive/lib/jdo-api-3.0.1.jar, /opt/cloudera/parcels/CDH/lib/hive/lib/datanucleus-rdbms-3.2.9.jar, /opt/cloudera/parcels/CDH/lib/hive/lib/datanucleus-core-3.2.10.jar, /opt/cloudera/parcels/CDH/lib/hive/lib/datanucleus-api-jdo-3.2.6.jar, /opt/cloudera/parcels/CDH/lib/hive/lib/antlr-runtime-3.4.jar, /opt/cloudera/parcels/CDH/lib/hive/lib/hive-cli-1.1.0-cdh5.8.4.jar, /opt/cloudera/parcels/CDH/lib/hive/lib/hive-exec-1.1.0-cdh5.8.4.jar, /opt/cloudera/parcels/CDH/lib/hive/lib/hive-jdbc-1.1.0-cdh5.8.4.jar, /opt/cloudera/parcels/CDH/lib/hive/lib/hive-metastore-1.1.0-cdh5.8.4.jar
  5. Set other parameters based on how you want TDCH to process the data.
  6. Save the file with the name
    InfaTDCHConfig.txt
    .


Updated October 05, 2018