DSXchange

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

- Exports jobs in a dsx
- Take a coffee
- Then go for load stage and options in the dsx

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.