Hi,
I have about 1000 jobs in on of my project and we need to find load strategy applied in each target table. Is there any automated way to achieve this, other than opening each job.
Thanks
Identifying load strategy
Moderators: chulett, rschirm, roy
-
vinothkumar
- Participant
- Posts: 342
- Joined: Tue Nov 04, 2008 10:38 am
- Location: Chennai, India
If you have metadata workbench installed and working you might want to check that out - it could be helpful. Try looking at Job Design metadata.
However, if not, the DSX strategy would also work. I'd suggest using something like Ultra-Edit editor with macros to examine the DSX files. Properly built macros could output a list of job names interspersed with the table methodologies you are looking for.
However, if not, the DSX strategy would also work. I'd suggest using something like Ultra-Edit editor with macros to examine the DSX files. Properly built macros could output a list of job names interspersed with the table methodologies you are looking for.