DSX - XML: CHANGE WIDTH OF FIELD IN MANY JOBS

[sangi1981]

Hi all,
we have a project with some thousands of jobs, parallel, server.
We need to change the width of a column from Decimal(2) to Decimal(5) in all jobs.

It is unthinkable to make it through an implementation task.
So, is it possible to apply the change directly to DSX or XML file, containing the entire project?

This is not standard activity, but is there some documentation or some workaround to find all occurences to substitute?

Thanks in advance
Sandro

[ray.wurlod]

Good governance requires that it be done through some kind of approved implementation task, even if that task ends up being a global search and replace in a DSX file or XML export file. Be very careful that you only change the required attributes.

[sangi1981]

Thanks for replay.
I agree with you about good governance.
At this time, I'm doing feasibility study, analyzing the different alternatives.


I have a standard account, so I'm not able to see your post after:
"Be very caref" .....

Thank you

[rkashyap]

Do see steps listed in this post.

[sangi1981]

Thank you for your replay and link.


I'm also searching for more information about what string or pattern to search.

In my Jobs, I have a field called FIELD of type Decimal[2].

So I found many different case, but not exhaustive:

• 1.
  Name "FIELD "
  Description "FIELD : decimal[2,0]"
  SqlType "3"
  Precision "2"

• 2.
  FIELD\\:decimal\\[2\\,0\\]\\;

• 3.
  etc,...

• 4.
  other not known cases

Is there some general rule or is there some documentation,
or Do I Have to use an heuristic method to discover all patterns?

Thank you
Sandro

[rkashyap]

Searching for lineage may be more useful than searching for name patterns. Do you have Metadata Workbench?

[sangi1981]

What do you mean about "searching for lineage".
Workbench?

Can I identify all occurences similarly to that shown in my previous post, so that I can apply them to a search&replace procedure?


Thanks