DSXchange

Hi Monalisa, Welcome to Dsxchange :D !!! Bear in mind that the first approach to stop the job should be from Director Stop button. In order to avoid such problems. Now check if that jos is really running in background. Try using the Resource cleanup option available in Director to check if there is ...

What happens if you run in sequential mode or in single node configuration using APT_CONFIG_FILE variable for this particular job?

There is no reason the Stage can get corrupted. But with different stage and different method you are passing a different value atlest by different means. Are you trying to pass input parameter values through Sequential stage via Transformer? Can you check what is the difference between passing the ...

AthiraM wrote:Yes, I believe the topic can be marked as resolved.

If so, its you who need to do it.

You conditions look ok.
What is data type of CUST_SEG_NBR? Char or Integer.
If its Char or varchar, try to convert it before the comparison.

Because all the data available in CUST_SEG_NBR is >= 000701700.

Would you mind marking the topic as Resolved.

What is the size of input file? Try doing few more tests, 1. Try to read the input file with the specific metadata and directly write into a file. - This will ensure, the is issues is not with the data which doesn't comply the metadata, where the Datastage may try to convert implicitly. 2. Read the ...

Hi Athira, Do you think that the topic can be marked as Resolved..

Most probably its due to the Arrysize. Is it given as 1000?
Make sure its given as 1.

As you said, all these functionality can be clubbed in single Transformer. Did you try to break the file and run the job?

No straight forward method in Datastage, unless you go for routine. LEVEL function from Oracle as mentioned by Havoc, would be more simpler.

In this case, does your Transformer stage does such a complex calculation, like comparing previous set of records or something? Where the set of record which you have might required more memory to involve. Can you break the problematic file in to two. Probably a limit of 14million and try to run two...

True. If MKS took kit is installed, you can invoke Unix commands in DOS.

As I mentioned in my previous posts, the VALUES section will be (seq_order_no.nextval,:1,TO_DATE(:2,'YYYY.....
Make sure you dont have the sequence column defined in Transformer. Dont you see that, it marked Red without proper derivation.