Going from SQL Server text column to Oracle data type
Posted: Mon May 15, 2006 11:14 am
Have you had experience taking a SQL Server text column (source) to an Oracle data type (target) and care to share your experience?
I've read several articles and most indicate the near-equivalent to a SQL Server text data type is an Oracle LONG. But given the LONG restrictions (not available in a WHERE clause or pretty much anything except a SELECT) it makes me question the value of bringing this data over.
The requirement comes from wanting to be able to view this data in a drill-thru from an AS cube. (They actually want to search it but that isn't doable from a LONG.) I just think that between the drag on ETL performance and the drag on the drill-thru queries, it seems impractical.
Opinions pro & con welcomed. Thanks.
I've read several articles and most indicate the near-equivalent to a SQL Server text data type is an Oracle LONG. But given the LONG restrictions (not available in a WHERE clause or pretty much anything except a SELECT) it makes me question the value of bringing this data over.
The requirement comes from wanting to be able to view this data in a drill-thru from an AS cube. (They actually want to search it but that isn't doable from a LONG.) I just think that between the drag on ETL performance and the drag on the drill-thru queries, it seems impractical.
Opinions pro & con welcomed. Thanks.