Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Mapping to trim all columns

666702Oct 22 2008 — edited Apr 15 2009

Hi All,
I am wondering if you have any recommendation on how to do data scrubbing (trimming, data conversion, etc) in owb mapping?
For example, I would like to TRIM all the columns (say 200 of them) in a source table and move them to target table. Currently, I am using this expression operator, and its a pain to repeat the same steps for all the 200 columns. do you guys have any suggestions?

~Prabha

Locked Post

New comments cannot be posted to this locked post.

Locked on May 13 2009

Added on Oct 22 2008

#data-warehousing, #warehouse-builder

8 comments

3,219 views