DSXchange

Hi All, I want to pass one or multiple values through a job parameter which will be used in IN clause of a SQL. E.g. Job parameter : Destination SELECT * FROM DEST WHERE DESTINATION IN (#Destination#); Destination will have varchar values as ABCD, XYZ etc. If I am taking the job parameter as string ...

Thanks for your suggestions ! I have tried below command but it can't recognize it. Ours is SunOS 5.9, may be that's why it didn't work. $ lsattr -EHl sys0 | grep maxuproc ksh: lsattr: not found I was also checking the ulimit option to get the resouce limits and below is the output as in production,...

Hi All, Few jobs are failing in production with below error. node_node1: Fatal Error: Unable to start ORCHESTRATE process on node node1 (<ETL server name>): APT_PMPlayer::APT_PMPlayer: fork() failed, Not enough space My understanding says that it happened when the transactional volume of these jobs ...

Hi All,
Is it possible to copy hash files from unix command line ?
If yes, then can anyone please help me with the exact command ?

Thanks in advance !
Ankita

Hi All,
Our project is hosted in one etl server (Say A).We need to
write some files to a diff unix server (Say B). Is it possible to read from a unix server and write to a diff unix server using a job ? If yes, then what are the necessary steps ?

Thanks in advance !
Ankita

Thanks Ray!

Thanks for the reply ! Can you please help me to understand the meaning/significance of following attributes as shown in job report ?

- Job WaveNo="1"
- StageStatus="10"

Is there any documentation where I can find these details ?
Also what is 'DIY technique' ?

Hi All, I am using DSJobReport to get the job statistics in xml file format.One job will be designed to read all such xml files and populate into a table.Since for each job level of details will vary, is there any way to find out the master list of attributes that can be generated through this repor...

As per my understanding, changing Oracle partitions into sequential will again make the load sequential, but is there any way to avoid deadlock even with parallel loading ?

Use join instead of lookup keeping the inputs hash partitioned and sorted on join keys.

Regards,
Ankita

Hi All, While trynig to update a Sales fact table using 4 node the job is failing with the following error: ORA-00060: deadlock detected while waiting for resource It's a update only query and input is hash partitioned on keys. Target table is range partitioned on date and job is running fine when d...

The error message starts with " Open failed for update " followed by the update query and finally with below error code,

sqlcode is: -60
esql complaint: ORA-00060: deadlock detected while waiting for resource

With single node it's running fine in dev, but the same job is running in production with 4 node configuration without any issue. It's failing even with input hash partitoned with keys. Why can it fail with 4 node ? Can it fail even if records are different but belong to same Oracle block ? No other...

Hi,
I am using Oracle as target with 'User defined update only' option.
While running the job with 4 node configuration it's throwing deadlock problem to update approx. 63,000 records .
There is no duplicate record in the input stream, what could be the reason ?

Thanks in advance !
Ankita

Hi, Ours is a item scalability project where we are testing with huge volume of data. Objective is to find out the breakpoints and then scale up the system accordingly.That's why I wanted to know how to estimate scratch space while doing join. As per my experience, in normal scenarios this space pro...