Hi,
Can we find out which fields are used in the matching job from the deployed script.
For example : if we lost the front end UI job but the job is already deployed on the unix server. using the deployed job I want to find out which fields are used in each pass of the matching job.
I think it is very tricky to find out that.
Help in this is really grateful. Thanks in advance.
Regards
Vijay Kumar
Can we get Fields used in Matching from the deployes Script
-
- Participant
- Posts: 59
- Joined: Sat May 29, 2004 12:31 am
- Location: Pune
Vijay,
am I correct in interpreting your question to mean that you would like to reverse-engineer a Px job? If so, you do not really have too many options and those depend upon how your job was promoted to the production environment. In any case you will only see generated code and scripts and will never be able to fully re-create the job design.
am I correct in interpreting your question to mean that you would like to reverse-engineer a Px job? If so, you do not really have too many options and those depend upon how your job was promoted to the production environment. In any case you will only see generated code and scripts and will never be able to fully re-create the job design.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 59
- Joined: Sat May 29, 2004 12:31 am
- Location: Pune
Vijay,
I don't think that the generated code will tell you column names for data transferred; at least I can't think of a way to do it. But there are brighter heads out there who might be able to tweak orchestrate and give a solution. Good luck.
I don't think that the generated code will tell you column names for data transferred; at least I can't think of a way to do it. But there are brighter heads out there who might be able to tweak orchestrate and give a solution. Good luck.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
This isn't Orchestrate, it's QualityStage (the software formerly known as INTEGRITY from Vality).
I think, if you inspect the execution scripts, you would be able to recover the field names manually, but as to the column widths I think that would be trickier. Unfortunately most of the metadata is contained on the client machine in a password-protected MS Access MDB file. (You could ask Ascential - via your support provider - for the password, explaining your situation, but don't hold your breath.)
Did you ever export your QualityStage project in an IMF format? If so, you could definitely recover from that.
I think, if you inspect the execution scripts, you would be able to recover the field names manually, but as to the column widths I think that would be trickier. Unfortunately most of the metadata is contained on the client machine in a password-protected MS Access MDB file. (You could ask Ascential - via your support provider - for the password, explaining your situation, but don't hold your breath.)
Did you ever export your QualityStage project in an IMF format? If so, you could definitely recover from that.
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.
Vijay & Ray,
sorry, I only saw the Parallel part of the description and didn't realize we were in the Quality Stage forum. Please ignore my remarks if you haven't done so already.
sorry, I only saw the Parallel part of the description and didn't realize we were in the Quality Stage forum. Please ignore my remarks if you haven't done so already.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Re: Can we get Fields used in Matching from the deployes Scr
This is more a Windows answer than a Unix answer, but it's the only one I got and have no idea if there is a Unix equivalent.Vijay Kumar wrote:Can we find out which fields are used in the matching job from the deployed script.
If you can locate the working directory where it compiles all the scripts where running, find the directory which has the same name as the stage, then look in there. The .MAT file contains the matching job, and lists all the field names (note: assumes you know in which order the files are if all the fields have the same name), and the .DIC file will tell you for each file the fields, their starting positions, etc.
(Basically, look for .MAT files.)
Alternatively, if the pass generates a .OUT file (in the Scripts directory), then all the info is also in there. (Very useful are .OUT files.)
Cheers,
Jamas
You have to develop a good practice of keeping records of the jobs developed. However, the people who put QS on their resume do not realize how important it is to keep track of the .IMF files.
The need for reverse engineering comes from the lack of a best practice that was put together by previous developers.
Whatever you do , DO NOT USE .MDB files on clients to accomplish this practice. Just use something like Sharepoint to store IMF files and back them regularly.
The need for reverse engineering comes from the lack of a best practice that was put together by previous developers.
Whatever you do , DO NOT USE .MDB files on clients to accomplish this practice. Just use something like Sharepoint to store IMF files and back them regularly.