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

No comments:

Post a Comment

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...