Question

Advantages of Teradata over Informatica

Answer 1

• Cheaper (initially): No initial ETL tool license costs. There is only less OPEX costs as one doesn’t need to pay for yearly support from Informatica Corp.
• Great choice if all the data to be loaded are available as structured files—which can then be processed inside the database after an initial stage load.
• Good choice for a lower complexity ecosystem.
• Only Teradata developers or resources with good ANSI/Teradata SQL/BTEQ knowledge are required to build and enhance the system.