DSXchange

Welcome to Dsxchange!!! :D

Was the data that been fetched is more that 2GB?
Do a reset of the job and look for "From the Previous log..." event, which will give you more information which may not be available in the previous run log.

With this stage, was the home directory home/dsadm/Ascential/DataStage/DSEngine been created?
Is seems like waiting for to press Return. Have you tried hitting Return at the last step?

Delete C:\HashFiles\vijay before you trigger you job, and recreate the file while you job waits for the file. You ll find everything happening as expected.

As specified in the error, have you tried the user with full permission. Try with the user id through which you installed.

If you are going for Upsert method, droping index before loading will inturns degrade the performance. Upsert should look for the presence of key in the table before loading into it. Index will help for this.

Log into $DSHOME if not set, use cd `cat /.dshome` to go to your Datastage Home directory. And find where your project been installed. You can find from your Adminstrator client by selecting the project. And try to explore. I ment exploration is just listing the existing directories. And noting else.

If your requirement is to use the data for more that once, rather i would say twice in you job desing, you can approach the dataset. You need to populate dataset using one job, which will have its own i/o, dataset will also be read and written. But will parrellel execution. So first explain on whats...

Force compile to reduce records
Are you getting confused with DumpSore?
What is your job desing?
While running the job, you will have the limits like 'Stop stages after n rows' you can use that.

May be your upstream jobs activity might produce some file For testing purpose, just check if you get the result as expected if you execute by commenting the file count. #!/bin/ksh typeset -i a=0 typeset -i b=0 #a=$(ls /path1/*.txt 2>/dev/null | wc -l) #b=$(ls /path2/*.txt 2>/dev/null | wc -l) if ((...

Hi Anu,
Again where you get these case from? Perhaps you havent mentioned here.
There are several other ways of acheiving this. http://www.dsxchange.com/viewtopic.php?t=88639 You can create a parallel routine as well.

Still you ll end up in using all the CPUs.

What is your director log shows for the Command Output? If you give condition for 2, will that work to execute notification activity?

What is the output you are getting? If you try with A and B, where you getting B instead of A?

Try printing the values other that 0 and 1, say A and B and check for the same. It will help you identify if 0 is returned due to other chances. Check the output of the CommandOutput in datastage as well.

If the Modify stage is just of the give purpose, why cant't both transformer and Modify stage be clubbed? You can perform the task in Transformer stage itself.