All Forums Database
vprem.vasu 5 posts Joined 02/12
15 Oct 2015
TPT Limitation - Not Supporting multi line values

Hi,
Recently I have noticed TPT is not handling multi line text box fields. I am loading data from Oracle to Teradata using TPT. One of the field has data like below (multi line values for a record)
"Hi
thanks for your feedback
Welcome"
 
When we try to load, these values aren't considered as single field, Can some one suggest is there fix for this in TPT. We have handled it using replace function, by replacing newline & linefeed with special characters while extracting and loaded them into working table in TPT.
after that replaced those special characters by newline & linefeed respectively using Oreplace function in Bteq. Kindly sugggest is there a way to handle it in TPT itself without doing all these or is it limitation in TPT.
 
Thanks,
Prem.

You must sign in to leave a comment.