Question: how to extract data from excel in informatica?
Answer: b) Click on Insert> Name> Define option. c) Type the name of the range and select the range on “Refers to:” space. d) Save the spreadsheet, Normally this kind of sources are saved in a specific folder (\Informatica\PowerCenter8. ...  c) Click on Add and choose Microsoft Excel Driver (*.