Flat File as Source in Informatica

How can we receive source as flat file in informatica, from where we get this flat file?

Questions by Rinky   answers by Rinky

Showing Answers 1 - 4 of 4 Answers


  • Apr 18th, 2016

Flat file is one of the major source formats received in ETL process. These files are received mostly from those source systems where Informatica cannot connect to extract data, for ex -mainframes, third party data etc...


  • Jun 22nd, 2016

To explain it clearly we have to know the concept of using FTP.
Consider a banking project, the product owner gives all data to production team and not to developer, the 3rd party team gives another data in flat files. These team enquire the customers who are eligible for Loans and give the data to developer not directly. They just paste the data in server and by using Winscp, the developer pastes the data into their servers and again load the new data by lookup on target tables!

  Was this answer useful?  Yes


  • Jun 18th, 2017

We get flatfile from source to target, which is in file format like MS-Word, etc

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions