Originally posted by: muralee

i want to retrieve the mapping rules from the database using DBLookup and they should automatically be executed

For example ----

below is my rule

=if(ClaimID ClaimFields:In1="1234","ITS-P","ITS-i")

instead of typing this in the mapping rule bar , i will fetch this rule from the database and it should get executed automatically ,

we tried doing this using DBLookup , but TX is not executing this as a usual rule , but just taking this as a
textitem.

can you please provide me solution how to execute this as command in the mapping rule bar.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

Yep, that would be nice but WTX maps are compiled not interpreted. Using the map utilities, mexport.exe, mimport.exe, mcompile.exe. You could export a map source to XML, modify it via map rules, import it, compile it, and then execute it. Presumably this would be done via a series of RUN functions within a map.

Is it practical? Probably not but give it a try and let us know how it goes.

I have used a template file as input that was referenced in map rules with nested IF statements to give a sort of a business rule repository and run time variable maps. It worked reasonly well for supporting customer specific X12 EDI IGs until the standard maps were modified in an attempt to work in every possible situation which resulted in spaghetti code map rules.

Jim Divoky
EC Solutions, Inc.
30-606-6826
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: janhess

Not quite sure why you would want to do this. You would never be able to tell in MapDesigner what your map was trying to do.
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: SystemAdmin

There are very good reasons for wanting to store one's business rules in a business rule repository and retrieve them at run time. Instead of losing track of what your map is doing, you have all business rules stored in a single database where they are manageable, secure, ans easily examined. Having a hundred maps that do basically the same thing with the exception of some minor differences such as one finds in EDI environments is not an efficient use of manpower. At the location where I implemented my template file technique for example, I had a single map for all 855's and was allowed to bypass the QA process which eliminated several days or more when implementing the transaction for a new trading partner and this was at a very strict organization under FDA review.

Business rule repositories are used for more sophisticated solutions than EDI but I haven't worked with any. Search on the term and I'm sure others can explain the methodology better than I.

Jim Divoky
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: janhess

Ah that's a good ues. What you need is a preprocessor that populated all the rules prior to build.
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: muralee

Do we have any preprocessor kind of mechanism to populate all the rules prior to build?

Can you please help me out, by providing sample code or example?
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: janhess

You'll have to write your own.
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: SystemAdmin

How about?
1. Create your template map
2. Export it from the Map Designer creating an XML file.
3. Use an XSD inference engine to create an XML schema from the exported map.
4. Generate a type tree from the XSD file
5. Populate the map rules as required using the export map file type tree as the target
6. mimport.exe the created map export file creating a map source file
7. mcompile.exe the map source file
8. Execute the compiled map
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: SystemAdmin

I don't know about saving the mapping rule in the database, but wouldn't a lookup table work for the original question? Design a table with FieldName, Source, and Target, i.e.

FieldName Source Target
ClaimID 1234 ITS-P
ClaimID 6789 OTHER
NewField ABCD 99
NewField ZXYW 77

Then you could write a rule that finds the Target value or uses the default ("ITS-i") if no record is found.

Anyone see a flaw with that?
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: janhess

The rule for the lookup would have to contain the field name it's going to look up. The idea if holding the rule in the database id to find rule 26 for instance and that rule can be anything that will validly map to the output field (I think).
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange