Question: how to import excel file in informatica?
Answer: Create Relational connection in Informatica Workflow Manager: To import the excel file you need to configure connectivity with the PowerCenter Client: a) Open Informatica Power Center Workflow Manager. Go to Connection and select 'Relational…' and click on 'New'. b) Choose ODBC from the list options.