Skip to main content
Question

How to compare schema CRCs

  • April 26, 2018
  • 1 reply
  • 9 views

dollargis
Contributor
Forum|alt.badge.img+6

Thanks to @david_r, I am able to calculate CRCs from schemas now.

The next problem arises when comparing those CRCs in the following setup:

My deliberation is that the CRCs are calculated one after the other and the tester waits for both results to arrive. But as you can see from the attached log , it does not happen in that sequence so the test does not give the expected results. What's wrong?

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

david_r
Celebrity
  • 8394 replies
  • April 26, 2018

It doesn't work because here the features either have _crc_1 or _crc_2, never both at the same time.

Before using the Tester, insert a FeatureMerger. You can e.g. merge the features based on "fme_feature_type_name".

Look out for any features exiting the UnmergedRequestor or the UnusedSupplier ports. These features will indicate a table that's not available in both schemas. See the FeatureMerger help for more information on these ports.

After the FeatureMerger, you can use the Tester to compare _crc_1 with _crc_2.