Going from SQL Server text column to Oracle data type

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
RodBarnes
Charter Member
Charter Member
Posts: 182
Joined: Fri Mar 18, 2005 2:10 pm

Going from SQL Server text column to Oracle data type

Post by RodBarnes »

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.
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”