How to Profile Multiple Sources or Inputs in the Same Profile

Reported for version 10

A profile is generated by the Profiling step. By default, the Profiling step accepts only one input, but more inputs can be added as endpoints to be connected by flows of data within the plan. This also allows creating referential integrity checks (i.e. foreign key analysis).

In order to do that, do the following:

  1. Double-click Profiling step.
  2. Click the Add Input icon  in the upper left corner and specify the input name in the next dialog window.

  3. After computing the profile, you can access the different individual profiles (and alternatively, their roll-ups if any were set) from a drop down menu at the left side of the opened file.

You can remove an input by clicking Remove Input .