Hello everyone. I need to determine the impact of changing a data element that is being used in many jobs across a single project. I'll keep it to three jobs for now.
Job1 extracts the data from a db2 table and writes it to a flat file. Job1 calls it column_1
Job2 reads that data and performs some update then writes the data to a new file. Job2 calls the column_A
Job3 reads Jobs2's new file and performs and update and writes the data to a new file. Job3 calls the column_X
Is there a way to find column_1 in all the different forms across a project and jobs?
Thanks in advance for any help
Finding a data element in a project across jobs
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
By "data element" do you mean a DataStage Data Element?
If so, your easiest solution is probably a global search and replace in an export file - structure of Data Elements in the DSX file is simple.
If so, your easiest solution is probably a global search and replace in an export file - structure of Data Elements in the DSX file is simple.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
All, turns out that the customer has the MetaData Workbench product. They have installed it over the weekend. I have used the links below and see a report I can use. I have almost 200 attributes I need to process and need a batch processing or custom query solution. I'm starting a new post in the MetaData and IBM MetaData Workbench.
Impact Analysis reporting
(scroll down to the relevant section):
http://publib.boulder.ibm.com/infocente ... ports.html
Here's the URL about how to actually do the analysis:
http://publib.boulder.ibm.com/infocente ... lysis.html
Impact Analysis reporting
(scroll down to the relevant section):
http://publib.boulder.ibm.com/infocente ... ports.html
Here's the URL about how to actually do the analysis:
http://publib.boulder.ibm.com/infocente ... lysis.html