How can handle multiple lines into a single line in data sta
Posted: Wed Sep 20, 2006 3:46 am
Hi,
My source coming from access database in that table one field contain multiple lines data that field data type is memo in access same i transformed into target(DB2) but in target stored before and after data stored some junk values how can i handle in data stage and which fuction will usefull.
My source coming from access database in that table one field contain multiple lines data that field data type is memo in access same i transformed into target(DB2) but in target stored before and after data stored some junk values how can i handle in data stage and which fuction will usefull.