DSXchange

Arun
Just kill the processes on that job name first... when DS throws message like monitoring means.. ur job process is still running or hung!!

Then compile your job.. it should work!

Hi
you can just use update sql with explicit condition that fails update statement.. like
where
.
.
.
AND 1=0

this should solve your problem

Hi Satish
This defeats the purpose of having datawarehouse in place!! Ok.. if you want to keep your target intact with source.. only way is reload the target on a defined frequency!! BTW what is your load frequecy?

I would also suggest to go with Aggregator stage. Usage staging variable will almost takes same time. If no other go you can go ahead with DSguru suggestion, partition on key1, key2 and key3 and sort in the input link of the transformer. Introduce a RDUP stage after transformer to retain the last re...

Hi,
I am also facing the same issue! MAXTRANS value for the table to be updated set to 255. APT_CONFIG_FILE is set to 1way.apt.

After the above settings, job started updating around 100K records however 200K records are getting rejected!!

Any thoughts?

Thanks
Madhav

Hi, I'm exploring, is there is anyway to reuse the lookup stages? I mean, In the input stream to lookup stage has 2sets(4) of columns I want to perform lookup based on each sets and output the matched rows. Can it be done in datastage? I am told it is possible in Informatica. can anyone throw some l...

Hi, I need to meet the following requirement. cust_no telno skey_telno(generated output column in transformer ) 1 12 1 1 23 2 1 NULL NULL 2 25 1 2 45 2 3 20 1 3 NULL NULL Basically based on the input columns cust_no, telno I need to generate skey_telno in the target table as shown above. 1) In the s...

in transfer from "beforeRec" to "outputRec"..

I am also getting the same warning while using CC stage.
FYI both the input page of CC stage has the column(s) which is there in output of CC stage but still the warning is populated.

Can anyone advice me on this?

Ray,
I used this option to generate log details.
Is there is any way to avoid manual intervention.
I mean can we execute any commands to automate this for all jobs in a folder?

Thanks
Madhav

Hi Jayawant,

The smartest way could be in the target stage chane the sql generation to
"auto insert/update" and then import the metadata.

so u will find all the columns automatically in the insert & update sections, then go for editing.

Hope this helps.

Thanks
Madhav

Just in the modify or Transformer stage...
"edit derivation" and and use the function suggested.

You can also follow the following process if u hv access to DS Administrator Using DS administrator. select project wherein the job is locked select COMMAND button type DS.TOOLS select 5 (Administrative tasks) select 4 (list all locks) you might need to resize the window to view all the data write d...

Hi We are struggling to make decission whether to go for Audit stage or Normal Transformer approach. Our case is like Business rule going to be keep on added and also going to be huge... The option we r thinking is: 1. Use audit stage and define rules as filters and generate exception table and use ...

In case of server jobs you can invoke the job using

$DSHOME/bin/dsjob -run -mode NORMAL -rows n <project_name> <job_name>

Thanks chulett