Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What are external tables and does Warehouse Builder support them?

April 26, 2017builder external support tables warehouse

0

Posted

What are external tables and does Warehouse Builder support them?

1 Answer

0

Posted

External tables are user defined database objects mapped (field by field) to flat files. The flat file fields must be defined either by delimiters or by field position. After an external table has been defined, it is possible to use read only SQL commands to access the underlying flat files. Warehouse Builder 9.2 supports external tables as data sources and allows users to define external tables from a flat file within Warehouse Builder.