DSXchange

Thanks for your response Kumar. Please correct me if I am wrong I was of the opinion that, If we use a dblink and filter out the records in the user defined SQL and then use only one Oracle stage that would be fast. Will the use of DBlink in the SQL a bigger overhead then joining two Oracle stages u...

Hi All I wanted to check with you all to see if using a dblink to fetch few more columns from a table in a different Oracle database would be better compard to use two Oracle enterprise stages and use a lookup between them. Which one would be performance wise better. When is it best to go for dblink...

Thanks for your prompt response ArndW. Can you let me know how to configure it.

Can we configure Oracle enterprise stage for Remote server then??
Or it cannot be done as ds_is_fun says??

Hi ArndW

Will it not make difference, if my Oracle is not on the same server where DS is. Should i not prefer ODBC in case where, Oracle is installed on a different server.

ODBC stage and Enterprise stage have almost all functionality same in 7.5.X versions. ODBC is more generic and versatile, so why not use it inplace of Enterprise stage.

It is a PX job. The moment I run it, in logs it shows me starting job followed by info: Environment variable settings. It goes till here. Then it hangs it seems. The job has Source an oracle stage a lookup which also uses another oracle stage a transformer and two output links going respectively aga...

Hi All

When I run a job from director, it gives SIGNIT error. While if I re run the same job from designer it finishes successfully.

Please let me know what is this SIGNIT error and why it happens.

Thanks in advance

Hi All

Some of the jobs running in production region keep on running continously.

This happens occasionaly. Is there any particular reason why this happens.

Could you please let me know how to avoid it.

thanks in advance

Probably I missed the "/ " while copying

Is there any specific reason why such a thing happens and that too inconsistently.

When and why are these scripts called upon

Thanks in advance

Hi Arnd The file is created run time and it may or may not get created depending upon certain validations. But We do have this kind of error for few more jobes these are listed below Internal error - missing script file RT_SC737/OshExecuter.sh internal error-missing script file RT_SC8741 oshExecute....

Hi All

One of our production job gets aborted once in a week with the below error message.

Parallel job reports failure (code Internal error - missing script file RT_SC690/OshExecuter.sh)

please could you guide me why it happens as out of 1 out of 50 runs this thing happens.

Thanks in advance
Atul

Yes Ray you must be right that one of the stage infact(Oracle enterprise stage) must be sequential. In the info which I obtained from Director after using Environment vartiable Dump_Score, it shows that ds0: {op0[1p] (sequential Oracle_Enterprise_0) The create script for the table which i am calling...

As mentioned i tried using dump_score environment variable to make out. below is the info which it provided main_program: This step has 3 datasets: ds0: {op0[1p] (sequential Oracle_Enterprise_0) eAny<>eCollectAny op1[3p] (parallel APT_TransformOperatorImplV0S2_OT_Transformer_2 in Transformer_2)} ds1...

I just designed a simple job having Source Oracle stage which has around 5 lakh records. A transformer stage and a target stage Dataset. I used Round Robin partitioning and found that: 3 node === 26016 rows per sec 2 node === 24932 rows per sec 1 node === 23016 rows per sec Time taken for the job to...