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

SQL Inline Views

SQL Inline Views

An SQL inline view is a SELECT statement in the FROM clause of another SELECT statement. For example, the following SQL includes an inline view:
SELECT ename FROM (SELECT ename FROM emp)
You can view data lineage on a database table, view, or synonym used in an SQL query with an inline view. The SQL query can exist in the following objects:
  • SQL override in a PowerCenter Source Qualifier or Lookup transformation.
  • Database views, stored procedures, functions, and triggers.
SQL inline views are also referred to as Common Table Expressions.

0 COMMENTS

We’d like to hear from you!