How to load Multiple excel source files with different structure into a target table in Informatica

I have a requirement to load a target table (Daily truncate and load ) using excel files as source and these excel files have different names to it like Plan code Mappings - API or Plan code Mappings - Main Frame . The excel structure is also varying , for example one source has 2 column and another has 4. Please let me know on how this can be achieved using Informatica Power center 10.4.0.

create a generic structure with max number of columns. for your example its 4.

1. create a shell script to create a list of those xl files.
2. create a new list file with all xlsx file.
3. create a session with a source with above max columns. ANd the map them to correct targets as per your understanding and filename etc.
4. delete files once loaded.

Now, i would recommend to use csv file and convert xl file to csv file for easy reading. for xlsx you need to use data direct driver, create new ODBC DSN and use it.