DSXchange

Want to get rid of PHP files in &PH& directory. This is what is shown in ph files after each job run:- [User@hostname &PH&]$ more DSD.RUN_37693_14850_558136 DataStage Job 337 Phantom 7978 The variable "APT_PERFORMANCE_DATA" is not in the environment. DataStage Phantom Finis...

APT_DONT_OPTIMIZE_MODIFY=1
APT_MSG_LINE=1

I applied these two values then also the &PH& files are getting created any idea, how to solve this so that it doesnt create any &PH& files.

I can store in Sequential File.

Could you please let me know how to use the job,

EtlGetRowCountsFromLog in the ETL stats folder

I imported all the jobs in my Project,

The folders i get is
ETL_Job_Params
ETL_Metadata
ETL_QA_Jobs
ETL_Reports
ETL_Row_Counts
Metadata
Misc
Can you Tell me in which folder what i have to change and go ahead and get the rowcounts for all the jobs which i have in my sequences.?

Also for

1 delete there will be one Delete as Update.

I want to get the count of my Target table which is a database and it is maintaining history, and i shd make sure the counts are correct both from the source side and as well from target side, for example 1 Insert is 1 Insert in Target 1 Update is 1 Insert plus 1 Update in target i.e 2. How do i get...

Its Oracle.

Could you please let me know in brief how to do this?
Thanks for the information.

This says me to maintain some tables in oracle which i dont want to do .

Thanks

Is there any script which does a count on the dimension table and the source table.? you know like how many INSERTS, how many UPDATES and how many DELETES in the target table. Could you please send me some template so that i get an idea on how to get the record couns based on I,U and D, UI , UD etc ...

Hi Ther can anyone tell me how to post a new Question?\

The job was built in the same project, then the data files for the job have most likely become corrupted. >>> yes i am facing the same problem, can you provide the steps to restore the job?