External Table to load

Database
Enthusiast

External Table to load

Hi,

in teradata are we can create external table for loading process without using load utilities. ?? in greenplum there are some external table
2 REPLIES
Teradata Employee

Re: External Table to load

Hi,

You can look into Table-UDFs for the similar functionality of external tables. Example can include Table-UDF over a text file, and then you can query it just as a normal table. Please note, there is a performance hit in it as it is more intensive task then reading from a normal table.

Regards,

MAC
Enthusiast

Re: External Table to load

Hi MAC,

Can you share more details on this. The table UDF over text file.

Thanks in advance.

Regards,

Shreya