I am getting a series of error messages like the one below. What does it mean and where do I resolve it?
JobFees : In Input_Insert elements are mapped to sources with inconsistent cardinality.
Regards, Charles
Date
Votes
3 comments
-
Mike O'Quinn Judging by the name of the node (Input_Insert), I'm assuming that this is a db table destination.
You will get this error when you try and map from 2 different data sets into one dataset. Meaning, all maps into "Input_Insert" must come from only one data set. If you want to combine multiple data sets, you'll have to use a "Join" transformation and join the data on some releated field into a single data set. Otherwise, you'll get the "inconsistent cardinality" error.
The reason for this error is that we can't be sure that there aren't a differing number of records coming out of each source data set you are mapping from.
-
Charles Kelsoe Thanks Mike - I am thinking that the issue was exactly that - I needed a Join to make this work. I ended up handling the need differently as I did not know how to create the new join then move all existing connections to the new join transformation. I did not want to have to redo each of the mappings.
-
Mike O'Quinn Hi Charles,
FYI, you can insert an action such as a Join transformation in-between by dragging and dropping from the toolbox, directly onto a bolded node. This will preserve all of your hard work (i.e. your mappings).
Please sign in to leave a comment.