DSXchange

We are currently running DS 6 on Unix and we have processes setup on analyst PCs to kick off DS jobs by running dsjob.exe from command prompt. We are in the process of upgrading to DS 8.1 on Windows. After we installed IS 8.1 DataStage client on user PCs, the dsjob.exe from command prompt stopped wo...

sjohnston wrote:Are there different or new ODBC drivers for SQL 2005? Could it have somethin to do with my OS being Windows 2003 64 bit?

DS is not certified to work with 64 bit systems. However, you might be able to create odbc in c:\WINNT\SysWOW64. You might want to change your OS to be 32 bit.

what directory do you search in for the files to find the last generate file such as JOB.2233901952.DT.1241931882.xxx?

Thanks.

velagapudi_k wrote:We used Routines to read the variables from parameter files, call them before the job actvities in the sequence when we are using Datastage 6. I guess thats the only option.

Oh well, I'll be changing the values for now.

How do I set user defined environment variables in DataStage version 6 so that when the values change, jobs can automatically pick up new values? Right now if I set up a variable, then add it to a job as a parameter, the job remembers the default variable value at the beginning. I can change the env...

If I already have my ASOF parameter in mm/dd/yyyy format, do I need to have TO_DATE? I can just say AS_OF_DATE = '#ASOF#', right? Are there ways to improve performance on DS jobs that pull data from Oracle? The table in Oracle has data for multiple months and I just pull one month. The same select s...

Thanks, I'll try this.

I have a job that extracts data from Oracle table to SQL. There is a where clause in the ORAOCI stage -- (TO_CHAR(AS_OF_DATE,'MM/DD/YYYY') = '#ASOF#'), where ASOF is a parameter. Is there a way to modify this criteria statement to use Oracle formatted dates (Ex: 31-May-2006), instead of 5/31/06? Wou...

ray.wurlod wrote:Is there an index on the sorting column?

Does it matter if I'm getting data from a view or table? I'm pulling the data from an Oracle view.

Thanks for your help with the sort suggestion. After I added sorting, the job did run without the mutex error message. However, now with the sort it takes almost twice as long as before. Do you have any ideas on improving the performance?

Thanks, DSguru for all your help. I did add order by clause in the select statement in Oracle stage. In my question I was referring to rwierdsm's statement that it will be much faster in database then DataStage ("If you can do the sort as part of your database read, do it there! The database wi...

rwierdsm wrote:The database will be much, much faster then DataStage.

Rob

If I'm pulling data directly from a table I'll need to switch to pull the data from a sorted view, right?

kumar_s wrote:Try to use IPC stage between two aggregator stage.

Thanks for the suggestion. I'll look into IPC stage. However, I only have one Aggregator stage.
Here is my job sequence:
Oracle Stage --> Transformer --> Aggregator --> Transformer --> ODBC

Let the aggregator know what keys the incoming data is sorted on. I need more help with some basics. In the Aggregator, under Inputs --> Columns, there are two columns Sort and Sort Order. Do I need to enter anything into Sort column? There is a dropdown box in the Sort Order column. The options ar...

Thanks for the quick reply. I'll try it.