on 08-31-2016 6:35 PM
Does anyone have a quick and easy way for locate hard coded values in a DS job? I have hundreds of jobs and am trying to find a good systemic way of locating possible bottlenecks as I approach a new conversion.
Thanks!
If you're on a recent DS version, 4.2 SP3 or higher, you can simply use the search functionality in DS Designer. From the official documentation:
"
Designer search capabilities
Using SAP Data Services Designer, you can search for a text string in every part of the object, such as table name and variable name. A new status line at the bottom of the Search window shows where the search was conducted (Local or Central), the total number of items found, and the amount of time it took to complete the search.
For more information , see "Searching for objects" in the Designer Guide.
"
Specify the value you're looking for in the Search all field:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
What if the search term is unknown? For example some mappings has hard-coded values of a different kind and datatype (ie: NULL, 0, 'ABC').
One approach I could think of is to export to ATL and use some editor like Notepad++ which allows using regex while searching and write regex looking for strings containing 'ui_mapping_text' but not the dot. Or something like that.
Thank you,
Viacheslav.
I haven't tried this, but I think if you export the jobs to XML format you may be able to search them for certain strings.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.