DSXchange

ketanshah123 wrote:Hi Kuamr
just want to make sure....the solution provided you....Using the sort stage..
It assigns 1 to first occurance of key value and duplicate key values with 0 ?

Yeah, you are right, and following post gave the condition to check for duplicates as well.

DSguru2B wrote:You can provide the constraint in the transformer itself and avoid the use of Filter stage.

Any specific reason, if Transformer can be replace by Filter, it should be good isn't?

"ORA-00942: table or view does not exist"
Check at which stage you are getting this error? The table that you mentioned may not be avaialble in that database. May be mis spelt, or lack or permission, or wrong schema name give by mistake...

Is it the similar patter of values for all the rows? And is it the 6th field?
Check this post for same error.

What was your job design? Datastage will be so fast that sometimes, the first record might reach the target before even it gets created. And the directory gets created anyways. As Arnd mentioned, you can use BeforeJob subroutine for this.

Under current project folder. Yes its the place where DSParams resides.

Row ID be your key based on which you identify its duplicate.

What is your source? How are you getting the original value?

Make sure you are not using any relative paths. You can use return code to check the completion of the code so trigger the rest of sequence.

You can use Sort stage with "Create Key Change Column" and a Filter stage to filter out the values with 0 would be more simple. But you have many option which includes manipulation of the data from its source itself. Database or Ascii file.

As you, yourself mentioned in your post, clear the status file will just change the status from running to compile, but the process will continue to run in background. Even that might be one of the reason, where you previous process of the job might be still running, while you might be trying to exe...

As you, yourself mentioned in your post, clear the status file will just change the status from running to compile, but the process will continue to run in background. Even that might be one of the reason, where you previous process of the job might be still running, while you might be trying to exe...

If a particular job is hanging always, you will need to focus on that particular sequence and its jobs. If you say, its about reading from a table and writing to a dataset, there might be a case where that table might be locked by some other jobs or process which been executed parallely. And when th...

Is it any multiple instance job or something? Is that the only particular job hangs every time? What does that job do?

Have you searched for "Hardware and Software Requirements"?
Linux should be same as AIX but with the changes that been mentioned.