Recent content by mpcurry

Try using : -paramfile $PM_PARAM_DIR/$PARAMETER_FILE as argument to pmcmd command.Where $PM_PARAM_DIR is environment variable pointing to the directory of parameter file and $PARAMETER_FILE is environment variable for your parameter file name.

Hi vln, What if it is not a valid number and I want to reject that record with an error message in the session log. Regards.

Yes, Autosys can be used for the same by using file watchers in the Autosys. I won't be able to provide you more details on this but it is possible using Autosys.

Yes you are right, we won't be able to implement this. By same I meant that my query is also doing the same thing : 1) It creates three fields (website,size and place) on the basis of value in the value field. 2) Perform the aggregation using MAX function. Regards

Forget it..Its difficult to implment and moreover it is exaclty the same as suggested by T.Blom.

Hi, I'm new to informatica, but I think I can solve your problem by using SQL skills : 1) Take visit as your source table. 2) Amend your source qualifier to overide the sql with following : select visit_id, max(decode(name,'website',value,null))...

I appreciate your comments to enhance the performance of my wrong(?) idea, I'm sure there will be several other ways to achieve this. But you have still not explained how my idea is wrong? I guess this will do the job (if not efficiently).

Also, can I request you to explain your solution further as to how can we replace inner loop with update statement.

I'm sorry Dima, Are you suggesting something new or is it an explaination to prove that above idea is COMPLETELY wrong.

Please try this : select a.orion_tank, b.OrionCrude, a.prop_modified_value, a.DayInserted, SEQ5_CRDINV.nextval, sysdate, user from ps_staging_data a, ps_crude_map b where a.Orion_tank = b.OrionTank and to_char(a.dayInserted,'dd/mm/yyyy') = to_char(sysdate, 'dd/mm/yyyy') and a.validated = 1 and...

Can you please explain.....

Hi Dima, I've quickly written something, by using FLAG variable, to exit from the outer loop, it might be wrong but I'm sure something of that sort can be done. Regards Ajay.

COMMIT is after the inner end loop; Regards

Please use : SELECT ADJUSTER_NO, MAX(TRUNC(CASE_OPEN_DATE)) FROM AUTO_CLAIM GROUP BY ADJUSTER_NO By Using TRUNC, it will truncate the time stamp on all the dates. Regards Ajay.

Hi Mike, Can I suggest you to create an extra column on your driving table say upd_flag and use this column to open your cursor like create or replace procedure SomeProcName as cursor SomeCurName is select awhole,bunchof,stuff from AReallyBigTable where...