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