Post reply

problem in loading

  • June 5, 2008 at 4:43 pm

    #121799

    Currently, we have a patient record that is correct in the old environment. When we run the data extraction process, the records are still correct. However, during the data load process into the data warehouse, an additional row was added to the patient record and appeared on the patient's statement in the data warehouse environment. Queries and reports have confirmed the additional row was added at the data load process.

    This is the problem I am facing,

    Let any one suggest me to get out of this problem,

    thanks

    p

  • June 5, 2008 at 6:07 pm

    #825202

    Are you using a loop of any kind in the data load process?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • June 5, 2008 at 9:22 pm

    #825241

    Given that information, there's no way we can help.

    What is the load process? In SSIS, you could split things out, copying the record, in T-SQL, you could have a cross join or other unintended problem.

    You should go through your process and check the results at each stage. If you are confused about why something happens, post some code and we'll try to help.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply