Exforsys
+ Reply to Thread
Results 1 to 3 of 3

Hi

This is a discussion on Hi within the Data Warehousing forums, part of the ERP category; Hello Can anyone say is there any possibility to have duplicate rows while coming inside mapping.Since they all are cleansed ...

  1. #1
    srivaidekhi is offline Junior Member Array
    Join Date
    Dec 2006
    Answers
    2

    Hi

    Hello
    Can anyone say is there any possibility to have duplicate rows while coming inside mapping.Since they all are cleansed through Cleansing tools when it comes to ODS it filters,then how it is possible,if so could anyone explain it with real time example.Thank u


  2. #2
    srivaidekhi is offline Junior Member Array
    Join Date
    Dec 2006
    Answers
    2
    Hi

    --------------------------------------------------------------------------------

    Hello
    Can anyone say is there any possibility to have duplicate rows while coming inside mapping.Since they all are cleansed through Cleansing tools when it comes to ODS it filters,then how it is possible,if so could anyone explain it with real time example.Thank u


    srivaidekhi
    View Public Profile
    Send a private message to srivaidekhi
    Find all posts by srivaidekhi
    Add srivaidekhi to Your Buddy List


  3. #3
    zsk_00 is offline Member Array
    Join Date
    May 2006
    Answers
    38
    take the duplicate row from target table and check back the same row in the source table to see if you have duplicates.

    If you are joining the source table with another table in the source qualifier, you might get duplicate rows if the join is not complete or not done properly.


    •    Sponsored Ads



Latest Article

Network Security Risk Assessment and Measurement

Read More...