I am trying to learn how to set up a Match Analysis using 2 source files/tables. I found a example mapping in Marketplace, but it won't import into my Developer Tool (running IDQ 9.5.0).
Does anyone have an example on how to do this?
Here's what I've done:
1. Create 2 PDOs from Oracle tables
2. Add PDO's to mapping as Read transformations
3. Connect ports from PDOs to Key Generator transformations (each PDO has its own Key Generator)
4. Connect output ports from Key Generators to Match transformation. The ports from the first Key Generator connect to the Match, but when I try to connect the ports from the second Key Generator, I get the error "Concatenation disallowed on transformation".
I figured this one out on my own.
In the Match Transformation, you select Properties > Match Type > Field Match (Dual Source). This creates a second Input group (which I didn't see initially). Back in Match Type, Set the Value for your Master Data Set (Input or Input1 in my case). Select the Match transformation in the workspace editor and scroll down its port list until you find the Input1 group. Connect your second source's ports to the ports here.