Teradata Loader Utilities For Informatica


Below are the loader utilities for the Teradata.       
  • FastExport : Extracts data from Teradata
  • FastLoad : Loads large volume data into an empty Teradata database table.
  • Multiload : High load batches and performs update, insert, upsert, and delete operations against Teradata database tables.
  • Tpump : Moderate to high loads and performs update, insert, upsert, and delete operations against Teradata database tables in near real time mode.
Things to evaluate while choosing Teradata PT mode
  • Limited Database Resource
  • Data Volume
  • Concurrent Processing
  • Real-Time
  • Constraint Based Loading
  • Data Accessibility
  • Restart complexity
  • Debugging complexity

Popular Posts

Featured Post

Basic unix commands used in Administration

ls –ltr                Shows all the files and sub directories in the  current directory. ls –la                  Shows all the hidden...