Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
When we create a mapping load table, is there a way to see that table in the table viewer (or somewhere else)?
You can create another table if you want to keep it.... May be like this
Table:
LOAD Column1,
Column2,
Column3
FROM XYZ....;
MappingTable:
Mapping
LOAD *
Resident Table;
No, you will not see the mapping table in the Table viewer, If you want to see it then remove the the word 'Mapping' before the load statement and take a look. Hope this helps...
You can create another table if you want to keep it.... May be like this
Table:
LOAD Column1,
Column2,
Column3
FROM XYZ....;
MappingTable:
Mapping
LOAD *
Resident Table;
You can create the same table without using mapping load. You just need to be careful that it may change your data model, and you will see some unexpected results.