Auto mapping target fields from source in informatica

etl informatica-powercenter informatica
Aspirant picture Aspirant · Feb 20, 2013 · Viewed 11.2k times · Source

I hav a source structure in informatica like

col1 number   col2 varchar(40)   col3 DATE   col4 varchar(50)   col5 number

and my target definition is like

col4 varchar(50)   col1 number  col5 number  col3 varchar(40)  col3 DATE

If i want to load the source records into target i will map the columns appropriately from source to target in a zig zag way

I just want to know that if there is any concept like informatica will automap fields from source to target based on column names i.e if the target columns are shuffled but the column names are the same ...

any suggestions regarding the same would be helpful ..

Answer

Marek Grzenkowicz picture Marek Grzenkowicz · Feb 20, 2013

PowerCenter can automatically link ports between transformations both by position and by name.

You should use the latter:

  1. click Layout > Autolink by Name,
  2. select the mapping object that you want to link (e.g. source) and drag the selected ports to another mapping object (e.g. target).

Related questions

Informatica writes rejected rows into a bad file, how to avoid that?

I have developed an Informatica PowerDesigner 9.1 ETL Job which uses lookup and an update transform to detect if the target table has the the incoming rows from the source or not. I have set for the Update transform a condition …

Read More
What is the required language knowledge to use Informatica effectively?

In the next few weeks, my company will be engaging multiple vendors to establish a choice for a common global ETL tool - not necessarily one that can't be broken from, but just where our license investment will go to …

Read More
Import Excel spreadsheet columns into SQL Server database

I have an Excel spreadsheet that I want to import select columns into my SQL Server 2008 database table. The wizard didn't offer that option. Do any easy code options exist?

Read More