Tables created when you reverse engineer a complex file in ODI

When you test a complex file connection in ODI it creates the tables in the back end for all the complex types in your schema file.

Along with that it also contain the following table

_SNPSXMLTBL - this contains the name of all the tables created without schema prefix

_SNPSRDBIDGEN - this contains the name of all the complex type in your NXSD

Here Schema is the name of the schema that you have provided before testing the connection