Mapping load - how to see the table?

[#1]

Hi everyone,

When we create a mapping load table, is there a way to see that table in the table viewer (or somewhere else)?

[trdandamudi]

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...

[sunny_talwar · Accepted solution]

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;

[alexpanjhc]

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.