Write to Hub
The Write to Hub stage can be used to link data together, resulting in a complex network of relationships called a hub, which can be displayed in a model. Once that model is created, it can be queried against in a Read From Hub stage or a Query Hub stage, or it can be visualized in the Relationship Analysis Client to identify relationships and trends that otherwise may be hard to find.
To configure a Write to Hub stage, you need to complete the Entities tab and the Relationships tab. You can also use the Options tab to set processing preferences and determine how you want data to be written to the hub.
Click here for examples of configuring a Write to Hub dataflow from start to finish using a flat file and an XML file.