Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. SarahGT

    Need SQL examples to validate historical data population

    Okay, so the test would be successful if no rows were returned considering the fact that all A.ORDER_ID was loaded properly from the source DIMENSION_TABLE_Z.ORDER_ID? In the event that the test fails I would get back Z.ORDER_IDs that do not exist in the FACT TABLE. In other words please...
  2. SarahGT

    Need SQL examples to validate historical data population

    PHV, If I run your query and A.ORDER_ID has no NULL values in the FACT_TABLE will I get any results back from the query? -Shawn
  3. SarahGT

    Need SQL examples to validate historical data population

    Do you think this will be an efficient way to test considering the records are being populated into the fact table are in the millions? Could I export to excel data from the Dimension table(SOURCE) and export the same data from the fact table(TARGET) and add an excel calculation to check for...
  4. SarahGT

    Need SQL examples to validate historical data population

    Hello All, I'm new to this site and pretty new at using SQL. Here is the scenario: In trying to improve Rpting performance a DBA has taken commonly used attributes from DIMENSION_TABLE_Z, which are ID fields, and has added them to FACT_TABLE_A. The DBA's actions created and populated the...

Part and Inventory Search

Back
Top