DSXchange

Do a search on dscc. I got some 32 posts. read through them.

disadvantages of using Aggregator Stage? here you go: 1) It takes up space on your designer canvas. 2) You will have to sort the data before you use aggregator stage. Again space on the canvas. 3) When running it takes up valuable CPU time, resource/scratch space. 4) And aborts all the time on the l...

In my understanding using multiple stages will not give a better performance. And most likely will be an over head, because Oracle will still read the full data thrice and then select the records. Not sure though. But if the table is partitioned then the a single oracle stage will be able to read in...

Any reason for not using XML source stage? You can import the metadata for the XML file from the stage. What have you searched on? ls command will give a list of files in a folder. what are you trying to do?

Do you mean upper case to lower case? And remove spaces if any? Look at the functions Convert(), DownCase() in a transformer stage.

Do a search on "ORCHESTRATE step execution terminating due to SIGINT", see if one of the posts help. Firstly set the APT_DISABLE_COMBINATION to true and see which stage is causing the problem.

Tell me the answer for the b+y= and b+z= first? Then i will tell you how it can be done in DataStage.

You tell us what to do? How do you expect the string to be calculated? Do you want a concatenated string for Col3_1 and Col3_2?

This is what the document says. So possibly only one command. But have you tried to execute multiple commands? What happened?

Firstly do a search on the full error message. Are there any other warnings/errors in the log?

I have read somewhere in the forum that the memory has to be explicitly handled in the parallel routine. so the free(OutPut). I dint know that the parallel engine will take care of the memory clean up.

Not clear. I dont understand your requirement. Where do you want to use this connection information? In a third party tool? Disabling triggers can be done in the open command in the oracle enterprise stage. Regarding load options search for "APT_ORACLE_LOAD_OPTIONS" in the forum here, and ...

ray.wurlod wrote:Just curious; where does the variable called "i" get its value? You test it in

Code: Select all

(i == 0) 

...

Copy paste error. I changed it in the post. Tested it and it is working.

This is a parallel routine that i wrote. And meets your requirement. #include <stdio.h> #include <string.h> #include <stdlib.h> char* DeleteChars(char *inputstring) { char *OutPut= (char *)malloc (sizeof(char *)); int length = 0; int StringLength = strlen(inputstring); if (length == 0) OutPut[length...

All environment variables are stored in DSParam file in your project directory. But this is not the best approach. And also i dont know any other way. So use it, but very carefully, till the time someone here has a better approach.