I know that Informatica is a software that extract data from data sources (database or flat file) and convert them to the same data types respectively so it will be easier for the source definition to map and load data to the target definition (database or flat file). What if the source definition and the target definition are loaded with different tables like (Like tables without the same columns) will it still work? 

I have a few questions regarding to informatica..

Informatica :

```
 Source Definition - Upload data from a flat file or data from tables in the database
 Source Qualifier - It is normally created with the source definition which is to be used to manipulate the imported data to match with the data type in informatica, which later to be linked with the target definition.
 Target Definition - It is created to store the only filtered columns needed for the target structure.

```