User`s guide

User’s Guide 45
CHAPTER 5
Advanced Concepts and Tools
Content Explorer
Content Explorer consists of a menu, a toolbar, a SQL structure area, a
Navigation area, and the Design area. From the Content Explorer window,
you can customize the size of the areas. You can also control the structure
of the SELECT area by using the commands available in the Options
menu.
Use Content Explorer to do the following:
• Browse the table catalog of any connected database of the current
project in the Design section
• Easily create SQL queries by using a powerful graphical user
interface
• Review the generated SQL statement
• Execute SQL queries against the database
• Browse the data of a selected table or view
• Create a table in the schema
• Delete all records of a table
• Count the number of records in a table of view
Topic Page
Content Explorer 51
Inspecting log file information 49
Managing jobs and scheduled tasks 49
Customizing SQL and transformation rules 51
Using multiple engines to reduce job execution time 61
Analyzing performance data 63