top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Mapping of a source file from fat file in Informatica designer

0 votes
443 views

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.

posted Oct 31, 2014 by Amit Sharma

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

1 Answer

0 votes

You can simply create a mapping with one source and multiple targets connecting all the ports to their corresponding targets. This way you'd read the source once and populate all targets at the same time. This however assumes that no other processing is needed.

answer Nov 3, 2014 by Shweta Singh
Similar Questions
0 votes

I am new to Informatica and I am trying to learn it bit by bit.Currently I am able to enable the repository services but nothing works after I get connected. As in the transformation icons do not get highlighted when I open the mapping designer. Please find the attached screen-shot. Let me know if any questions.
enter image description hereThank you.

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

+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

Design a mapping to load the first record from a flat file into one table A, the last record from a flat file into table B and the remaining records into table C?

...