DSXchange

WHEN WE CLEAR &PH FOLDER THE JOBS & PROJECTS RUNS FINE.WHAT IS THE REASON ? HOW DOES THE IMPACT TAKES PLACE? WHETHER IF THE JOBS FINISHES IT SEARCHES FOR ANY KIND OF ENTRY OR READ THE ENTRIES OF PHANTOM LOGS IN @PH FOLDER? IN SERVER THE MEMORY OCCUPIED BY &PH IS FOUND TO BE VERY NEGLIGIB...

Hi craig, I have cleared &PH with mandatory precautionary steps as this will improve the life of the project and hope make the jobs run quicker. The steps followed are 1.)Check whether all jobs has been stopped 2.)Bring down the DSEngine 3.)Clear the &PH 4.)Start the DSEngine I have cleared ...

Hi Ray,

Thanks for your reply,

How to find, whether each field is populated correctly or not

Thanks & Regards,
Arun

I seperated the fields as you mentioned in the previous posts,but i need, how to check the presence of required fields and format of fields. Suppose in the record a value for a column is mismatching with the metadata given, i should reject the entire flow for that i need to find the invalid records....

what is the difference between lookup,merge,and join stage?

Hi

How you import the table definition.

Hi, When I worked with sequensial file I have tried 'No of Readers per Node' option to make the extraction process faster.But the result I have got is just against :shock: . Following are result of my trails. Start Time - Production Run Time (in Sec) - No of Nodes 03 - 08 - 1 03 - 09 - 2 04 - 09 - 4...

Hi All, In my project i have two category(folder) namely business and working.I am keeping my final version of job in business category and all the developement activity i am doing in working category. Now my requirement is to protect the business category so thet only with some userid i can access ...

gurus, can anybody tell me what mkdb.file and create.file will do in the hashed file context.what kind of hashed file both the command will create? my second question is what are the problems in loking up a database table not a hashed file? please put some light on the above question. thanks in adva...

Hello, i have one problem,hope you guys will help me out. i have written a routine which i want to use as before job subroutine in the job properties.but i am not getting the written routine while selecting the before job subroutine in the job properties. so please tell me how can i do this? Thanks ...

Hi all when i try to load 1000000 rows into oracle database through DRDBMS stage i am getting the following warning. and also only 44000 rows alone got inserted into the table. TGT_CTY,0: Warning: TGT_CTY: ORA-01562: failed to extend rollback segment number 5 ORA-01562: failed to extend rollback seg...