DSXchange

Hi,

What's DataStage Command Language? Can I get some documentation/links to get to know mor about this?

Cheers,
Mohan

Hi, I have requirement here. I need to run a SQL query on a table to find whether the desired values are present. If yes, then I need to execute a stored procedure. Can I achieve it in the following way? I have a job containing three stages, a source Oracle/ODBC stage, a transformer and a target Ora...

Hi,

I need to create a sequential file based on a condition. I'll be running a SQL query in one of the jobs. I want this job to call another job only when the count of rows retrieved by the SQL query is zero (0).

How can I design my sequence?

Cheers,
Mohan

Hi, I installed MetaStage yesterday. After installation and restart of my machine, when I tried to run the MetaStage application, I encountered the error in a dialogue box: "Unable to start application. The Java Virtual Machine cannot be loaded - Class not registered". I then installed the...

Hi,

I was told that there's an Orchestrate document which narrates the behind the scenes of parallel processing. If any of you have the document, please send it across to mohan.suswaram@wipro.com and I would be grateful.

Cheers,
Mohan

Hi,

I forgot to ask this question in my previous post.

Do we need a partitioned database as the source to use Parallel Extender?

Cheers,
Mohan

Hi, My source database from where I extract the data has no partitions. If I use Parallel Extender for loading tables from source to target, and my source doesn't have partitions on it, then whether the use of Parallel Extender will add any value? I heard some contradictory statements which say that...

Hi,

I'm using DataStage 7.1r1. And if at all I could call the PL/SQL procedure, how can I get the statistics of rows read and rows loaded by the procedure using a DS job?

Cheers,
Mohan

Hi Ray and T42,

Let me know the variables/parameters that you need and I shall provide them. I need some approximate estimates.

Cheers,
Mohan

Hi, We have developed a sequence of around 36 jobs. Pretty-simple but looks pretty complicated. Now, we need to document what we have designed. Each job, each sequence and each link has been provided with proper names and appropriate descriptions. Now, is there a mechanism where I can get a document...

Hi, I have a PL/SQL procedure which has 5 cursors to select the data from the source systems and loads the data into a target table. The PL/SQL is robust and is working fine. I have a requirement where I'm asked to use the same PL/SQL. So, I have to call the procedure using Data Stage. Also, I need ...

Hi, We are doing a table to table load....it's a direct load from a source table to a target table. There are no transformations in the interim. Also, the target table has no database constraints like Primary Key and Not Null. But the only thing is that we are embarking on a table to table load inst...

Hi, Can I time slice the parallel jobs? What I mean is: say, I have to load 4 tables of 10 million rows each. Assuming each parallel job takes around 20 minutes to load each table, to start with job1, can I schedule job 2 to run 15 minutes after the first job (overlap of jobs 1 and 2) and after 10 m...

Hi, Thanks for the response. I need to know the approximate time taken to load the say 10 GB of data using Parallel Extender with 8 CPUs? I also need to know the technical details of how Parallel Extender executes a job. What does it do when it has to run a job that loads 20 million rows of data usi...

Hi, Is it possible to use checkpoints (savepoints) in a datastage job? What I need is to commit the data after every 1000 rows or after every 10 seconds. And if the job fails, then re-running of the job should start reading the next chunk of data from the previous checkpoint/savepoint and proceed fr...