DSXchange

Hi Welcome to DsXchange :D !!!

Basically its related to ORACLE_HOME not properly set in Datastage search path and hence could not load respective library. As mentioned, if you do a search you can find almost all the topics been dealt earliar.

Welcome to DSXchange :D !!! Whats your source? There are couple of post with the same error message. One related to increasing you timeouts from oracle end, and other related to increasing temp space or reduce the parallelism.. Altogether, its an Oracle issue. Speak to your DBA to solve this. But th...

Command line compile option. dscc. But available in client.
C:\Program Files\Ascential\DataStagexxx>dscc /h <hostname> /u <userid> /p <password> <Project> /j * [/ouc]

Not necessarily that it will be on different OS. But unfortunately its the case in many site to reduce the cost. Just because Windows license is cheaper and flexible than Unix. W.r.t Datastage, moving component is, just exporting the jobs from your development environment and importing back in the n...

Or add a script after the loop, which compiles the main job.

Planning has its own weightage. As mentioned, its purely depends on your source data and the business needs. The business requirements will be in such a way that, the DM1 will required only 5% of the operational data. Ray has mentioned, how even the 5% grows to 1000%. Calculate the capacity of indiv...

Hi,
And btw, pls avoid interview question in this forum.

In the example that you have given, CopyOfproduct_class is it a job or the Jobsequence that calls the Job?

Perhaps you can explain how you run all the jobs. In a loop? In a sequential order? If so how do you go to next? You wait for something?

All these Conductor, player, section leader are a name given to a process which controls others and created by OSH and hence DSEngine. Inturns all these are one process of OS. As soon as you start a job the flow mentioned by Ray starts. No matter how you start it, either from GUI or from BASIC code ...

Not sure if something happens at end of the extract, try to limit the number of rows say 100 or 1000 while running the job by giving Stop after 100 rows option. This will give the idea on which part was the actual problem.

What is the JobSequece desing?
Do you have any before job subroutine? Is it pertaining to only to Jobsequence or to all other?

2 should be for the check he made for the below code.
typeset -i a=0
typeset -i b=0
typeset -i c=1
typeset -i d=2

a=$(ls /path1/*.txt 2>/dev/null | wc -l)
b=$(ls /path2/*.txt 2>/dev/null | wc -l)

if ((a == 0 && b == 0 ))
then
print c
else
print d
fi

You are passing path as parameter. In that case it may not be exactly the same as you might be expecting. So you may need to watch it close by hard coding the path value or file name etc to avoid some silly errors.

Do find the output file been created? Was there any data that been populated?
Oraclel 9i stage is compatable with 10G. But as per your statement, other jobs which have 8i stages are working ok.
Do you see the rows been extracted from the statistics (Monitor)?