Getting started with Informatica and ETL

User_H76VH

Hi,

I have started learning about Informatica for my project and needs some direction from the gurus here.

I need to connect to a remote datasource with Informatica, which will perform ETL process

the data will need to be extracted from the datasouce,

mapping which will pulled certain fields / columns to the target

the target will be a CSV file which the mapped fields will populate the CSV file.

Here is my question,

Is the tool Informatica PowerCenter Developer? If that is not the correct tool, what is the correct tool and where can I download it.

I read that I can use Queries to join the tables in the remote source, correct?

When the data is extracted from the source, does it needs to be save or dumped somewhere? a table?

Most important, can I dump the mapped data into a CSV file?

Thanks and really appreciate your help

Gianni Ceresa

Hi,

For purely Informatica questions an Oracle forum isn't probably the best place.

Informatica is not an Oracle product, it's was just packaged into OBIA as the pack required an ETL, in current versions of OBIA Oracle moved to their own ETL: ODI.

So there must forums about Informatica on their site I imagine ...