source system upgrade ( impact analysis )
Moderators: chulett, rschirm, roy
source system upgrade ( impact analysis )
Hi All
We have two different source systems, one of the source system is upgraded. Due to that some views are changed.
Now I am doing impact analysis on existing jobs. We have over 1000 server jobs. Now I am doing manually each category wise.
Any one provides me script that may help me a lot.
Thanks
SReddy
We have two different source systems, one of the source system is upgraded. Due to that some views are changed.
Now I am doing impact analysis on existing jobs. We have over 1000 server jobs. Now I am doing manually each category wise.
Any one provides me script that may help me a lot.
Thanks
SReddy
-
- Participant
- Posts: 24
- Joined: Mon Jul 12, 2004 10:16 am
Re: source system upgrade ( impact analysis )
Generate HTML report from your project (7.5.1 onwards) and search for the VIEW Name. You will be hitting the job name here and it would help you do the impact analysis.
Re: source system upgrade ( impact analysis )
Thanks
Now i am using very recent production .dsx file. Buy using Edit Plus
I am searching each job using View names what they are given.
Any one have related experience in your projects.
Thanks
SReddy
Now i am using very recent production .dsx file. Buy using Edit Plus
I am searching each job using View names what they are given.
Any one have related experience in your projects.
Thanks
SReddy
sreddy wrote:Hi All
We have two different source systems, one of the source system is upgraded. Due to that some views are changed.
Now I am doing impact analysis on existing jobs. We have over 1000 server jobs. Now I am doing manually each category wise.
Any one provides me script that may help me a lot.
Thanks
SReddy
Re: source system upgrade ( impact analysis )
Hi Reddy,
I have developed a PERL script which will surely help you in your process, please mail me on my mail ID wasesoft@gmail.com, so that i can send you the PERL utility over mail.
Thanks,
Waseem
I have developed a PERL script which will surely help you in your process, please mail me on my mail ID wasesoft@gmail.com, so that i can send you the PERL utility over mail.
Thanks,
Waseem
Syed
---------
Wait and Watch
---------
Wait and Watch
Re: source system upgrade ( impact analysis )
Thanks SYeed
:D Good to hear from yours. definitely i can mail to you.
Waiting for your valuable reply with "PERL" script.
Thanks
SReddy
dwpractices@gmail.com
----------------------------------------------------------------------------------
:D Good to hear from yours. definitely i can mail to you.
Waiting for your valuable reply with "PERL" script.
Thanks
SReddy
dwpractices@gmail.com
----------------------------------------------------------------------------------
syeed wrote:Hi Reddy,
I have developed a PERL script which will surely help you in your process, please mail me on my mail ID wasesoft@gmail.com, so that i can send you the PERL utility over mail.
Thanks,
Waseem
Impact Analysis
Thanks for your valuable reply. I am following Usage Analysis.
Here i select the job just press the Usage Analysis Icon.
I found Relationship Type Category Name Source
related jobs and sequence jobs.
Out of these entire how can i check the jobs impacted with my view.
Can you send me briefly?
Thanks
SReddy
Here i select the job just press the Usage Analysis Icon.
I found Relationship Type Category Name Source
related jobs and sequence jobs.
Out of these entire how can i check the jobs impacted with my view.
Can you send me briefly?
Thanks
SReddy
chulett wrote:Have you tried the Usage Analysis tool in the Manager? It can show you every job that uses a certain bit of metadata, such as the metadata for your source views. ...
impact analysis
Thanks
You mean import the metadata first and then start the development right.
If i started new development, i have to do design mapping document.
Then starting development.
Thanks
sreddy
You mean import the metadata first and then start the development right.
If i started new development, i have to do design mapping document.
Then starting development.
Thanks
sreddy
chulett wrote:You would have had to have imported the metadata for the View and used it in your jobs. Then a Usage Analysis on it would show you all of the jobs that you've used it in. ...
impact analysis
Thanks
You are right, but in our project they are not maintain metadata correctly.
That is why i am checking with query that may fetch Jobname & Category.
After that i had take job report checking impacted target tables.
Thanks
SReddy
You are right, but in our project they are not maintain metadata correctly.
That is why i am checking with query that may fetch Jobname & Category.
After that i had take job report checking impacted target tables.
SELECT NAME FMT '40L', CATEGORY FMT '40L' FROM DS_JOBS WHERE JOBNO IN (SELECT OBJIDNO FROM DS_JOBOBJECTS WHERE EVAL
Thanks
SReddy
chulett wrote:You would have had to have imported the metadata for the View and used it in your jobs. Then a Usage Analysis on it would show you all of the jobs that you've used it in. ...