Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Data Source ( Text files)

Status
Not open for further replies.

v71168

IS-IT--Management
Feb 26, 2002
1
US
Can I build a univese on text file ( data seprated by comma)? If so, Is there any performance improvement of using text file (on local machine) as a data source v/s universe pointing to remote Oracle database?

Thanks
- V
 
V

Firstly it is possible to build a universe on a text file (example, connect through an ODBC connection where you can specify the delimiter).
To be honest I don't know what the performance implications would be although in my experience I have never had any performance problems populating a universe from a remote Oracle db (but all are different). Also if you used the txt file as a datasource you have the added step of running an ETL script to populate it.

Hope this is useful.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top