Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Output to CSV file

Status
Not open for further replies.

nab03

Programmer
Mar 29, 2006
6
JP
Hi ALL.. Im nab.
I have a question.
Im using Informatica PowerCenter7.1.2.

I wanna output to file as CSV file. like below one.
------ I hope this ----
"vcolumn1","vcolumn2","vcolumn3","iColumn4"
"data1_1","data1_2","data1_3",0
"data2_1","data2_2","data2_3",0
"data3_1","data3_2","data3_3",0
--------------------------

Generally..
when I use "File Writer" target, i could get below one.
-I dont like this format--
column1column2column3icolumn4
data1_1data1_2data1_30
data2_1data2_2data2_30
data3_1data3_2data3_30
------------------------

should I use "EXPRESSION TRANSFORMATION"?
please let me know easy way to get CSV file.
any idea?
 
You can define delimiters for flatfile output in workflow manager!!

Ties Blom

 
Thank you Blom!
I could output to CSV file. after changed target properties in workflow manager.

Thanks a lot!!


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top