DSXchange

Hi All, I need to implement SCD2 logic using datastage parallel job. We are using Netezza for storing data. I am using Netezza Enterprise stage and ODBC connector stage for this design. As Netezza is not very good at Updating records, I will be using following approach : 1. Check for src and target ...

Hey Ray,

I did not find ODBC connector in Datastage 8.1. Is this a new stage introduced in 8.5?

Thanks.

Thanks Craig.. It worked. The only problem is, I am loosing one record. If I use @OUTROWNUM=1 then that record is sent to the delete link and thus not get inserted into target table. For Now- I am storing that one record in Seq file and inserting back into target. Is there a better way to handle tha...

Thanks Craig for your reply.
I am trying to delete records from target table on certain condition.

Step 1: Delete from table where Col1='ABC'
Step 2: Insert into Target_Table.

Please let me know if there are any workarounds other than writing a Stored Procedure

Hi All,

I am using Datastage with Netezza combination. To connect to netezza, I am using ODBC connection. When I use ODBC stage, I can not see "Pre and Post SQL" options.

Is there a way to use this feature?

Thanks in Advance for help.

Thanks Ravi. That worked!

Ravi.K wrote:Try with uncheck "Log warnings after activities that finishe with status other than OK".

You can find this option at "Job Properties" of Sequencer.

Hi, I have a unix script which checks if file exist or not. If file exist then script returns 0 else 1. I want to handle return code like this: If return code =1 then run next job , if return code =0 then send email. My job design is like: Execute command------RC=1-------->Run sequence | | RC=0 | | ...

I have one sequence in which I have implemented restart ability. In that sequence there is one job which has been used 10 times. This job does nothing but update status. This job runs fine for 5-6 times with status FINISHED (no warning at all) and suddenly it don't run. When I checked in log message...

Thanks Ray. I tried that option as well. It does not run. But when I put entire sequence inside Another sequence and run then it runs fine, even without reset if required,then run option. The Job activities that run the subsequences need to have "reset if required, then run" option selecte...

Hi all, I have created one sequence with all necessary settings to make it restartable. My sequence design look like: Seq1--->Seq2 When my Seq2 aborts then it shows status as aborted/restartable. But when I restart it I get following message "sequence is not in runnable state" When I compi...

Thanks Mike for your reply.
If I don't compile and run it then it gives me error:
"Job is not in runnable state."

Mike wrote:Don't compile it (or reset it). Just run it.

Mike

Okay, So according to your suggestions I used terminator stage to abort a job after sending email. Now when job fails then it shows status as aborted/restartable. So after that I did following steps: 1. Changed failed job, compiled it. 2. Compiled the sequence job. 3. Ran sequence job But when I run...

So if I send email in case of failure then master sequence will never show as aborted. In that case I will not have restartability feature for this sequence.

Note: Inner and outer , both sequences send mail in case of failure.

Hi,

I have a sequnece which is calling 5 inner sequences.

For each inner sequence I have coded-
Now Can I send abort status to master sequence if inner sequnece fails in this scenario?

Hi All, I am running a server job which has source as Oracle and target as oracle. Our Oracle and Datastage are installed on separate servers. I have one SQL query which perform SELECT in 40 seconds. It Selects 20 million records. Now when I do same thing on datastage (select only--> by putting @FAL...