DSXchange

Hi did you get answer to your question. I have the same question actually.

Hi I have a select query with case statement and join with 5 tables to stract data from Sybase database. I want to insert the result set in Oracle database table (The table in oracle matches the stcuture of the o/p from SQL statement). I don't know where to begin. I tried adding SQL in DRS stage (co...

[quote="vmcburney"]The dynamic RDBMS stage is recommended if there is any chance they will switch databases on you at a later stage - for example if they plan on decommissioning Sybase and moving it to Oracle. If the c ...[/quote] Where does it pick up the connection information from ? .od...

Hi Folks, I am very new to DataStage ETL. I am working on a Job to transfer data from Sybase ASE 12.5 (Unix) to Oracle 10.x (Unix). What would be the best approch. I mean which stage to use Dynamic RDBMS ? Oracle OCI? Sybase stage ? Note: I have float & text datatype in the Source Sybase databas...