DSXchange

Hi all, When I tried to load around 1000 records to a Oracle table through OCI stage after reading from a seq file, lookup and some transformation, I'm getting error as below for 50 records and job aborted finally. "<job Name> got aborted with the following error: <JobName>.DefaultsLoad: <Updat...

Thank you ArndW.

Hi all,
I need to generate Project Name dynamically and assign it to a Job parameter.
Is there any function or Macro or Basic Interfaces available in 8.1 Server?

Many Thanks,
Poova

Thanks Ray. I will go with one DRS Stage per one link.

Thanks all.

Hi all, I'm also getting the same warning when I'm using DRS Stage to connect to Oracle DB. I'm having 1 stream input and 3 reference links. Warning Message is, \<stage name>: When checking operator: Passive stages should have either one input link or one output link. Other configurations may run, b...

Thanks a lot Ray.

Thanks a lot Ray.

Hi all, I need list of job names and execution time, day, interval for the jobs scheduled in data stage director. Instead of opening each and every folder and identifying the details, Is there any easy way to prepare report about the scheduled jobs. Any commands or any option available in data stage...

Ya craig. It is < 1 or < 2 i'm trying. I wil go with @outrownum rather than @inrownum.

Mean time, if any faced the same problem, Pls add a comment here.

I too facing the same problem. It looks like the above mentioned link is for 7.1.
If anyone knows, Pls share the steps to get rid of this problem in 8.1

many thanks,
Poova.

I have set "OK Conditional" between all JA and ExeCommand activities. It should be "Okay Conditional" according my requirement.

Thanks priyadarshikunal. My question is simply, when we run some activities in parallel in a job seq (no routine activity), without using exception handler will the job run all the activities even if any of activity failed. I thought "Automatically handle activities that fails" would suppo...

In Oracle, when you insert a empty string, this will be inserted as null I guess.

create table xx ( c1 varchar2(4));

insert into xx values ('');

select * from xx where c1='';
ans: no rows selected.

select * from xx where c1 is null;

Ans: c1
---

Thanks all. To be in safer side, I will order the key in Remove dup as same as order of hash key .

Hi all, I'm having a remove duplicate stage for which input link is from Copy Stage. I'm doing hash partition on x, y, z column in the copy stage and Same Partition is used on Remove Duplicate Stage with x, z, y as key columns to remove duplicate. Should the hash partition column order (xyz) and the...