How do I force UPPERCASE in Data Migration type MIGRATE_SOURCE_DATA? I have a Source column and I want to force UPPERCASE on import of data, how can this be done? Is it done at the Method attributes?
Best answer by Technical Outlaws
View original
How do I force UPPERCASE in Data Migration type MIGRATE_SOURCE_DATA
Userlevel 6
+13
Userlevel 5
+11
The Source Column in Source Mapping can handle SQL commands, so in your case you can just use UPPER(CF$_BRANDPARTNO) in the Source Column.
Userlevel 6
+13
That worked fine.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.