Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 7 Current »

An Equi Join returns only the rows that have equivalent values for the specified columns in all the datasources. For example, BENE_ACC_NO is the specified column in both DEMO_BENE_DATA table and DEMO_CT_TRAN_SUMMARY_DATA table as in the following screen shots. An equi join on these two tables based on the account number returns values that have matches in both tables.

Bene Data Table:

Tran Summary Data Table:

The following screenshot shows a report, Beneficiary Report created by combining Bene Data and Tran Summary Data data sources using Equi join operation:

Perform the following steps in Sigma Studio to combine data sources using EQUI JOIN option:

  1. Click Data Builder.


    The Data Builder menu option appears only when the CONNECTIONS on the left navigation is selected.
    The Data Builder screen appears.

  2. Enter the Name and ID of the data source aggregator in the Name and ID fields. Here, DATA_BUILDER_JOINS is used as the name and ID for data source aggregator.


  3. Select Parent Data source from Data Source ID drop-down field, which appears on the right-hand side. For example, BENE_DS2 is chosen as the data source.

  4. Drag and drop another data from the left-hand side and connect the parent data source with this data.

  5. Click the data element and select data source ID from the Data Source ID drop-down field. For example, TRAN_SUMMARY_DS2 is chosen as the data source.

  6. Click Join.

  7. Select any one of the Join options. Here, Equi Join is selected.

    NOTE:

    An equijoin returns only the rows that have equivalent values for the specified columns in all the datasources. Here, BENE_ACC_NOis the specified column.


  8. In the Join On Keys section, select the Parent and Child columns from the respective Parent Column and Child Column lookup fields.

  9. Click the Save to save the data source aggregator.


    A confirmation message appears.

  10. Click Ok.

  11. Now, proceed with the report configuration.


    On using the Equi Join option in a data source aggregator to configure a report, only the similar entries on data sources will be displayed based on the select parent and child columns. For example, consider the report shown on the following screenshot. Here, BENE_ ACC_NO 10001000233, the additional entry on Bene data source will be eliminated and only the matching data from the two data sources will be displayed based on the provided key column (BENE_ACC_NO).

  • No labels

Copyright © Intellect Design Arena Limited.

All rights reserved. These materials are confidential and proprietary to Intellect Design Arena Limited and no part of these materials should be reproduced, published in any form by any means, electronic or mechanical including photocopy or any information storage or retrieval system nor should the materials be disclosed to third parties without the express written authorization of Intellect Design Arena Limited.