Informatica 7.1: Can we use Excel as target?

In case of UNIX machine neither you can make Excel as source or target as there is no ODBC driver there in UNIX for this purpose.But,in case of windows you can make Excel as source but not as target.

Workaround:-
*** Contributed By Mr. Nitant Mahajan ***
1/
In workflow manager.
Set file properties-->keep delimeter as CSV-->Optional Quotes Double
* If your data do not contain COMMA then only COMMA delimer will solve the purpose *
File should be saved into .csv format.



2/
Set the delimeter as TAB and save file as .xls



---: I am not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m.a.hasim@inbox.com