DSXchange

Hi, I am on the performance tuning phase of the project. Need some help in how the data sorted in Sequential stage can be used as is without resorting. My Question is: I have an Oracle stage with 26 million records and to bring down the time taken to execute the job in datastage I want to push the s...

Hi All, I am on the stage of performance tuning our Datastage jobs and am a bit confused as to where do I need to re-sort if I have already Partitioned on a higher base key across all the Stages. My Queries are as below:- 1: Does the Aggregator stage retain the sort order in its output link same as ...

Thanks, dsedi, Not all files have the wrong pattern. Only reason why some of the files have different structure was because the jobs were created by different developers. Michael, I have used a reject link to Sequential file stage as suggested by you and am able to identify the files causeing the er...

Eagerly awaiting response

Thanks in Advance
Rohan

Hi, I have some 80 to 90 Datastage jobs. Each jobs creates a set of error files all with the same file structure across all 90 jobs. All these files created in seperate jobs are created in a single folder but with a common file pattern say "*_Seq_Err.txt". When I run a job that loads these...

Hi, I have a number of jobs running in parallel each having some million records: Some jobs are quite large in terms of number of Stages in each job. Job a : 35 stages Job b : 19 stages Job c : 12 stages Job d : 24 stages Job e : 14 stages Job f : 17 stages Job g : 14 stages -------------------- Tot...

Though this post is resolved. I guess the Run job command in below manner: Run job1 Run Job2 Run Job3 will still cause the Jobs to run sequentially since as soon as the first run job command executes it waits till the job finishes and then goes to the second run job command. We have to run them in b...

We have tried that too, Do we have to make a host entry for this on our windows machine. We have tried that as well though. have read some where it says we have to make some credential mappings for this. Do we need to first configure the Websphere Application sever before logging into IIS. Note that...

We have tried that too, Do we have to make a host entry for this on our windows machine. We have tried that as well though. have read some where it says we have to make some credential mappings for this. Do we need to first configure the Websphere Application sever before logging into IIS. Note that...

Hi All, I am unable to log into the IIS web console. We have our IIS server on an AIX server. During installation we have chosen internal User registries as an option, and now we are unable to log into the web console. Also what is the URL to access the web console via IE, we are unabl to open the W...

Thanks Arnd .....

Thanks Arnd..

Just to be very sure .. u mean that I can wite the statement as

C_ACCT <= 840999999
or
C_ACCT <= '840999999' .....

will both of them lead to the same result .....

Which form should I use ...preferably ........

Hello Friends,

I have some SQL queries using which I have to write DataStage Routines ... however one of the queries uses the Cast Operator In the folowing form:-

CAST(C_ACCT AS REAL) <= 845999999

I dont know the Basic Equivalent of this statement .........
Kindly help

Thanks in advance