create proxy_table is a variant of create existing table. Use create proxy_table to create a proxy table, but do not specify a column list. Component Integration Services derives the column list from the metadata it obtains from the remote table.
create proxy_table creates proxy tables that automatically inherit all the columns, column names, and datatypes of the external table using the following syntax:
create proxy_table table_name [ external type ] at pathname
create proxy table allows external object type table, file, and directory.The location information provided by the at keyword specifies the path name to the remote object.
External type can be one of the following:
external table (the default) specifies that the object is a remote table or view.
external directory specifies that the object is a directory with a path similar to the following: “/tmp/directory_name [;R]”.“R” indicates “recursive.”
external file specifies that the object is a file with a path similar to /tmp/filename.
