Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm working on an unknow database and I need to rename fields in order to avoid synthetic keys.
What I know is that I can rename a field by the FIELD_NAME as NEW_FIELD_NAME, but field by field only.
Is there a way to rename all fields adding a prefix or a suffix, without spend a lot of time with the "field by field renaming" ?
Thanks in advance
Bibo
Yes. Qualify.
Add before your load:
Qualify *;