Which transformer lets you join directly to data stored on the web without an additional reader?

• A. InlineQuerier
• B. DatabaseJoiner
• C. FeatureMerger
• D. FeatureJoiner

Answer: (B)

In FME, you can enrich or compare your input features with data that's stored in a database accessible over the web by using a transformer that joins directly to a database table. The DatabaseJoiner is designed for this: it takes your incoming features and joins them to a table inside a database through a database connection, matching on a key field. Because the web-hosted data lives in the database and is accessed via the connection, you don’t need a separate reader to fetch that web data before joining. The result is features that carry attributes from both sides, produced in one step.

Other transformers either operate on two feature streams (which would require both sources to be read or created elsewhere in the workflow) or don’t perform a direct web data lookup and join by themselves. InlineQuerier fetches data from a URL or inline query but isn’t a joiner by itself, and FeatureMerger/FeatureJoiner combine two streams but rely on the data already being present in the workspace.