Data Quality : Pentaho vs Informatica

Data Quality : Pentaho vs Informatica

Data Quality:
              Pentaho: Has DQ features in its GUI, allows for customized SQL statements, by using JavaScript and Regular Expressions. It also has some additional modules after subscribing.
              Informatica: Does not have that many DQ features, but there is another product called Informatica Data Quality which has many DQ features.

Monitoring:
          Pentaho: Has practical monitoring tools and logging.
              Informatica: Has extensive monitoring tools and logging.

 

[signinlocker id=”2555″]

Connectivity:
              Pentaho: Can connect to a very wide variety of databases, flat files, xml files, excel files and web services.
              Informatica: Can connect to a huge number of databases, mainframes, flat files, excel files and web services. It can also export as a web service.

Speed:
               Pentaho: The Java-connector slows it down somewhat. Also requires manual tweaking like Talend. Can be clustered by placed on many machines to reduce network traffic.
              Informatica: Is the fastest tool. It has an advanced “Pushdown” option that localizes transformation tasks depending on how busy the machine is.

Data Quality : Pentaho vs Informatica

[/signinlocker]

 

Leave a Reply