Table of Contents

Search

  1. Preface
  2. Using Metadata Manager
  3. Configuring Metadata Manager
  4. Application Resources
  5. Business Glossary Resources
  6. Business Intelligence Resources
  7. Custom Resources
  8. Data Integration Resources
  9. Data Modeling Resources
  10. Database Management Resources
  11. Universal Resources
  12. Managing Resources
  13. Loading and Monitoring Resources
  14. Managing Permissions
  15. Resource Migration
  16. Repository Migration
  17. Appendix A: Metadata Manager Login
  18. Appendix B: Metadata Manager Properties Files
  19. Appendix C: Resource Configuration Files
  20. Appendix D: Glossary

Metadata Manager Administrator Guide

Metadata Manager Administrator Guide

Tables in Join Statements

Tables in Join Statements

Data lineage includes a database table if data is extracted from or loaded to the table. If the table is included in a join statement but no data is extracted from or loaded to it, the table does not appear in data lineage.
For example, an SQL view includes two tables, CUSTOMER and CITY as described in the following SQL:
CREATE VIEW SF_CUST_VIEW AS SELECT CUSTOMER.ID, CUSTOMER.NAME FROM CUSTOMER, CITY WHERE CUSTOMER.CITY_ID = CITY.ID AND CITY.NAME = ‘SFO’
Because the view only exposes data from the CUSTOMER table, the CITY table does not display in data lineage for the view. Instead, data lineage displays the CITY table as a Related Catalog Object of the view.

0 COMMENTS

We’d like to hear from you!