Is it possible to use same external table for multiple files with same structure?
Or is it a good practice to have one external table for each file?
Regards, BI DWH BALA
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
Answer by BI DWH BALA · Nov 29, 2009 at 07:14 PM
It seems that, we can specify list of file names in external table definition if the files are having same structure.
Any other suggestions are welcome.
Answers Answers and Comments
No one has followed this question yet.
What is a 2 Phase Commit ?
Cost based optimizer (CBO) question?
Heavy MDX Query
How does one load multi-line records?
SSAS/Oracle Data Sources