DSXchange

Hi, We have a job which extracts data from Oracle DB. We have enabled RCP and pass around 70 tables to this job. The problem we face is that the output column order in extract file is not matching the columnorder of table definition in Oracle. Is there anyway we can enforce this column order on the ...

Hi,

I was able to get all columns of all required tables.
What if I just had to make a transformation to one column across all the tables I extracted.

e.g: Create_Dt needed to be Sysdate is all files that were created by the generic job

Can this be done?

Regards
Wah

Hi, I'm getting back to DataStage after a couple of years, so I apologize first in case the question below has been answered earlier. I tried searching but did not get the answer. I have 130 Tables in my ODS schema. Data from all these tables needs to be extracted everyday by using last_update_dt co...

Hi,

Does anyone have a ballpark figure for DataStage Server licensing cost?
I'm assuming it should be very low.

Just need to do cost comparison analysis vs SSIS.

It is tougher getting it from my software procurement team

Regards
Wah

Hi,

Thanks for the input, it really helps in decision process.
One of the main drivers of the change is that we are mainly an SQL Server shop. We have lot of DBAs comfortable with SSIS, and maintenance costs for SSIS will be much lower than Datastage

Hi, Currently we are planning to move 800 plus server jobs from Datastage Server to SSIS. We are trying to see if there is any functionality which is currently present in Datastage Server which would be difficult to replicate in SSIS. SQL Server is our primary DB, with a few connections to Sybase DB...

Hi, My jobs are not getting trigerred when I use dsjob. It was all working fine and then no job isgetting triggered. Now this is what I get :/apps/Ascential/Server/DSEngine/bin>dsjob :/apps/Ascential/Server/DSEngine/bin> PREVIOUSLY uadsgd31:/apps/Ascential/Server/DSEngine/bin>dsjob Command Syntax: d...

Hi Ray,

Our SSIS jobs are running faster on SQL Server 2008. But datastage has slowed down. The .odbc.ini file used VMmsss24.so driver to connect to SQL Server 2000. Is there another driver available for SQL Server 2008?

Regards
Ankur

Ahhh...Monday morning..no coffee..
'from' has been changed

It is server..post has been modified

Hi, We migrated our database from SQL Server 2000 to SQL Server 2008. We have noticed a steep drop in performance, the inserts are almost taking double the time. The only change we made was to point .odbc.ini file to new server. Does anything else need to eb modified e.g: ODBC drivers? See a sample ...

That works!!!

First use a vertical pivot so that all the rows with commmon keys come to the same line. So after vertical pivot your data should look like this 10 skp@gmail.com /data/dev/file /data/dev/file1 /data/dev/file3 /data/dev/file4 Now write a small unix script where " " in only columns after the...

But that is not my requirement, I need to map filename to each row