Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.
Kimball Forum

Discussion Group for the Dimensional Data Warehouse and Business Intelligence Community


BI/ETL TESTING

2 posters

Kimball Forum :: Topics :: Dimensional Modeling and Data Architecture

Go down

BI/ETL TESTING Empty BI/ETL TESTING

Post  Afroze9 Sat Aug 24, 2013 8:49 am

BI/ETL TESTING

Referential Integrity-Orphan checks, Foreign Key checks ?Can any one help me what is the QA strategy for
Orphan checks, Foreign Key checks ? is there any query to validate ?


Thanks !

Afroze9

Posts : 1
Join date : 2013-08-24

Back to top Go down

BI/ETL TESTING Empty Re: BI/ETL TESTING

Post  BoxesAndLines Mon Aug 26, 2013 9:15 am

For Oracle:
select fact.dim_fk
minus
select dim.dim_pk

For SQL Server:
select fact.dim_fk
except
select dim.dim_pk
BoxesAndLines
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

Back to top Go down

Back to top

- Similar topics

Kimball Forum :: Topics :: Dimensional Modeling and Data Architecture

 
Permissions in this forum:
You cannot reply to topics in this forum