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?
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?