This content has been marked as final. Show 4 replies
Take the data type as string for all column in your file datastore.1 person found this helpful
Now append " quote in mapping expression for those column except the date and number column in I$ table.
Dont use the text delimiter in your file data store.
Thanks for your reply.
It worked great.
can you suggest me any other way, may be by changing code in IKM or any other way of implementing this. Coz, This solution seems like we are hardcoding the quotes.
Edited by: BMK on Feb 1, 2013 11:47 AM
I dont think it will be considered as hardcoding because this is not a dynamic value. Its is just a quote. Where ever you provide, its going to be constant thought out the process whether it is given in text delimiter or in mapping tab. Again you need this only for varchar type column not for number or date.1 person found this helpful
And there is always alternative for every question. But i dont think other alternative (by writing a special KM or some jython code etc ) will be easier than this.
Let me know if you get something.
thanks for your help. we did it as you said.