• long_shanks64 (1/23/2013)


    BillyJack

    Q. Who implements the restrictions as to which business functions and 3rd parties have access and update permissions to this new attribute. Who decides how this new attribute will be initialised?

    answer: A IT. B. it doesn't matter C. we don't have time

    Q. Presumably this new attribute is of a certain data type, with constraints as to permissible values (possibly restricted to other existing entities and attributes). Who enforces this rule?

    answer: A IT. B. it doesn't matter C. we don't have time

    Q. Who make changes to the data capture applications? Or to the ETL to extract data to 3rd party systems. Or the existing operational reports. Or the existing analytical reports?

    answer: A IT (and their BI counterparts) B. it doesn't matter C. we don't have time

    Q. Who updates the enterprise data model and users' metadata dictionary?

    answer: A IT (and their BI counterparts) B. it doesn't matter C. we don't have time

    Q. Who enforces data quality checks on the new attribute?

    answer: A IT. B. it doesn't matter C. we don't have time

    If you answered A to these questions - IT are responsible for implementing these rules and controls. So they need to accommodate the new requirement AS PART OF THE OVERALL SOLUTION in a modification to the existing data model.

    If you answered B or C to these questions - :w00t: please see me after class.

    Just a little chippy for someone that doesn't have the correct answer listed for any of the questions. 😉

    --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)