All Forums Database
ardhie 13 posts Joined 06/10
03 Jul 2010
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

i'm excited
Adeel Chaudhry 773 posts Joined 04/08
05 Jul 2010

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

-- If you are stuck at something .... consider it an opportunity to think anew.

shreya_singh 4 posts Joined 10/12
10 Oct 2013

Hi MAC,
Can you share more details on this. The table UDF over text file.
Thanks in advance.
Regards,
Shreya
 

You must sign in to leave a comment.