top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Auto mapping target fields from source in informatica

+1 vote
979 views

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 ..

posted Apr 22, 2014 by Pooja Bhanout

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

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).

answer Apr 23, 2014 by Shweta Singh
Similar Questions
+1 vote

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 ..

0 votes

For cleaning up unused IPC-Sources I need a Repository Query for getting Workflow, Session, Mapping and Source/Target of Mapping.I have startet by joining REP_LOAD_SESSIONS and REP_TBL_MAPPING on mapping_id but only a fraction of mappings seem to be present in the joined output. I can't find the right tables to join to get the job done. Any help will be greatly appreciated!

0 votes

I have simple informatica(9.1) mapping(one to one) which loads data from flat file to RDBMS

it take 5 mins to load to Oracle db and 20 mins to load same file in SQL Server 2008 R2.

Can there be any source/pointers for performance improvement

0 votes

My source File Description:
In creating a mapping in Informatica designer where in my source is a fat file which is the collection of different types of data, as in customer details from customer table, his enrollment details from enrollment table and few more tables like this.
In this scenario how do I proceed in creating mapping and transformation to target?
If it were a single source file I define a simple source and target mapping.

...