Data Integration

Data Integration

Connect with experts and peers to elevate technical expertise, solve problems and share insights.

 View Only
Back to discussions
Expand all | Collapse all

DOUBT regarding DATASTAGE QUALITY STAGES - ONE SOURCE MATCH & STANDARDIZE stage

  • 1.  DOUBT regarding DATASTAGE QUALITY STAGES - ONE SOURCE MATCH & STANDARDIZE stage

    Posted Tue October 25, 2022 07:42 AM
    Hello All,

    I have having following doubts on DATASTAGE QUALITY STAGES, can someone please help me on this -

    1. In the ONE MATCH SOURCE stage, we have option to select MATCH SPECIFICATION, but no options are coming under it
    can someone please explain me or send any document mentioning complete details on it?

     


    2. Any extra documentations or videos on DATASTAGE quality stages?

    3. We want to execute below Use case via QUALITY STAGES-
     we have similar records in source file for example,
    ID INPUT_NAME Remarks
    1 CAPTIVE FASTENER CORP  Maximum portion of the string is similar
    2 CAPTIVE FASTENER CORPORATION
    3 CUTLASS FASTENERS INC  Unique
    4 ELGIN FASTENER GROUP Unique

    WE want to remove this similar type of records and want to get output as below-
    CAN SOMEONE HELP US IN ACHIVING THIS USE CASE?
    Note: Since, record 1 & 2 are almost similar we want only one records from the set and eliminate the other rec.

    2 CAPTIVE FASTENER CORPORATION
    3 CUTLASS FASTENERS INC 
    4 ELGIN FASTENER GROUP


    Regards
    Rajni

    ------------------------------
    RAJNI HARYANI
    ------------------------------

    #DataIntegration


Related Content