DSXchange

Hi Everyone, my every job is generating a single warning message as " WARNING: DataStage has found more CPU's on your system (4) than your current license allows (2). Please contact Ascential Client Support or your Ascential Account Manager. ". We have 4 CPU machine and our license is for ...

Hi Narasimha,

You are correct infact. But this is our requirement we need to do.

Please give me some start up idea.

Regards,
Suresh N

Yes Guru you are correct, I need 10,200 in sample data reject file.

Regards,
Suresh N

Sorry Small Correction. I have a Sequential File ===>AGG1 ====>XFM2 ..... I have a reject file to the AGG1 and i'm picking up the first occurance for my duplicates, the rest are rejected. Now my requirement is that i want to pick my first occurance and wanted to reject all my duplicates. How can i d...

Hi EveryBody, I have a Sequential File ===> XFM1 ====>XFM2 ..... I have a reject file to the XFM1 and i'm picking up the first occurance for my duplicates, the rest are rejected. Now my requirement is that i want to pick my first occurance and wanted to reject all my duplicates. How can i do that ? ...

Hi All, Please help me out with a solution... I have 50 jobs with one to one mapping from a source flat file to DB2 stage. I have a table with 2 columns with table name and row count. I need to create a job to populate the row count for the respective tables after all the 50 jobs complete. How can i...

HI, I'm using the Hashed file for only two options - Create File and Clear file before writing. Ray, I suppose it might not be the fault with DB because it picks up the result set based on the Business date and why is that when i run the job manually its giving me the correct result. Is it something...

Create file for all the Lookups

Yes they are distinctly named hashed files.

Hi DSguru and Chulett, Very Very Sorry For " ASAP ". I was in a tension for that. Please excuse me. I have 26 Lookup Jobs which are executed parallely, 4 lookups use the same table as a source with different where clause and likewise there are 2 sets of lookups which use the same table and...

Hi Gurus, I have a sequence in which 26 lookup jobs which are executed at once. Few jobs returned Zero rows even if there is a result set for the selection at source. When I run the same jobs manually these are returning 20000 rows and the same when i run again its returning 40000 rows. All three di...

HI Sridhar and All,

Problem is now resolved. Might be you are correct. This situation lasted for 5 mins and after that i was able to run my job.

Thanks for all replies.
Suresh N

Hi, Today i aborted a job and compiled it to re-run. Surprisingly after compiling the job started running with Zero rows per second and some 50000 rows being processed. I'm able to compile again and again but not able to run. Please help why this is so and what could be the solution for this.. Regar...

Hi,

Did you try that by using Oconv((Iconv(Date1,"DMY")-Iconv(Date2,"DMY")),"DMY") ??

Regards,
Suresh N

Hi Tejaswini, Every stage in Px which is having an input from another stage will have this check box option which is called as implicit/link sort(This option will not be enabled unless or until you select some partition mode). This means, if your input data has to be sorted (depends on your function...