DSXchange

i have data IN A SEQUENTIAL FILE LIKE 1|2|3 4|5|6 7|8|9 Now i want to convert this data to 123456789 in a single row. My job is sequentilal file----->row merger----->sequential file When i run the job by selecting MULTIPLE LINES my ouput file looks like 1|2|3 4|5|6 7|8|9 (when i checke in output se...

i have data IN A SEQUENTIAL FILE LIKE 1|2|3 4|5|6 7|8|9 Now i want to convert this data to 123456789 in a single row. My job is sequentilal file----->row merger----->sequential file When i run the job by selecting MULTIPLE LINES my ouput file looks like 1|2|3 4|5|6 7|8|9 (when i checke in output seq...

If affinity of job to CPU is what you are trying to accomplish, IBM has the solution for you :) If you use LPARs on an on a Power5 AIX system, you can designate CPU affinity and limit the CPU/Memory resources assigned to a Datastage EE job executing in that LPAR. Never say it Can't be done. Just th...

There's no such thing as a "CPU pool in each node". CPUs are totally independent of nodes. Processes are started from nodes; the operating system allocates processes to CPUs on a time-share basis. Even one process may visit several CPUs during the course of a long-running execution (but o...

ray.wurlod wrote:The optimum solution is a time dimension table with month granularity.

Sorry couldnt understand the solution. When i get 200705 value as a parameter i want to convert this to 200706. i cannot use add_months oracle function.

I am getting date in the from of "YYYYMM" as a parameter. Now i have to add one month to this param value. How can i do this. I am resctricted in using oracle functions. Do we have add_months like funtions in datastage.

Licensing for DataStage is based on the number of CPUs, not on the number of CPU cycles. Cycle (or MIPS) licensing is really only ever encountered with mainframe systems. That said, I am not aware of the DataStage licensing model on USS - check with your support provider. There is no relationship w...

The answer is a definite maybe. What does "brached" mean? It depends also on many factors, not all of them internal to DataStage, such as whether CPU cycles have to be expended on paging activities as each process exhausts its timeslice and gets another one. So one of the factors is how t...

How many loical nodes we have, or how many CPUS are brached to each logical node, the job always consumes the same numer of CPU CYCLES.
IS the above statement correct? Please let me know

for renaming fields, we have modify stage. We can even change the name of the field in copy stage. My question is do the copy stage really supports the assignment operation. When i tried its working, but people said sometimes is really dont work. Why do we need to have the expicit rename funtion in ...

i learnt that scratch disk has filesystems for temporary storage and resource disk has filesystems for permament storage. But i cannot understand difference between permanent and temporary. whenever we run a job all the data generated between source and target is temporary data. Now where is the poi...

can anybody help with this error pls

MATERIAL_DESC_EXCEL_ldr,0: Export failed. [new-impexp/file_export.C:1219]

Can anybody please list the available orchadmin util commands?.
I have checked the document and didnt find any information about all the commands

search helped thanks.

Hi all,

I am getting zero for every link in the job when i click show performance statistics, but the target table is populated with data! can anybody plz guide me to get correct stats back.