home -> academy -> InformaticaETL
On this page > Some configurations <> Exercising ETL... <> Advanced, good...
A VirtualMachine (VMWare-workstation-player) running Windows is used here on Ubuntu linux.

For example, you can use Informatica PowerCenter Express (on Windows), MS SQL server 2014 Express+RazorSQL db client.

Some configurations

MS SQL server, one scrshot:
File sqlserverConf1.jpg
Windows firewall, one scrshot:
File firewallConf2.jpg

Exercising ETL transformations

There are nice samples for many of the transformations.

Normalizer transformation, one scrshot:
File infaNormalizer.jpg
Mapping execution result in CustomersRes target table, one scrshot:
File infaCustomersResTable.png

Question: What is the content of the Customers source table? :)

Advanced, good practices

Best Informatica Interview Questions & Answers.

Enjoy!