The name of the DB2 Web Query development tool for creating reports
What is Report Assistant?
100
Condition caused by aggregation from two or more tables
that results in multiple matching rows and could return plausible but erroneous results.
What is the multiplicative effect?
100
A type of dashboard that displays multiple reports and graphs to show the current state of the business?
What is KPI (Key Performance Indicators)
100
Abstraction layer between DB2 for i and DB2 Web Query that describes the files and fields to be queried and can act as central repository for company's business logic.
What is DB2 Web Query metadata?
200
Existence of Select Omit Logical Files and creating queries over DDS Logical Files
What are two examples of SQE inhibitors?
200
The DB2 Web Query feature that gives users ability to slice and dice, drill drown, and analyze data in a multi-dimensional format
What is OLAP (Online Analytical Processing)?
200
The technique that can be used to push date conversion logic down to DB2 and result in better performance
What is the date conversion table (or calendar table)?
200
The name of the DB2 Web Query administrator group profile?
What is MRADMIN?
200
The NASA mission that failed because of a metadata problem?
What is the 1999 NASA Mars Climate Observer
300
Query/400, OPNQRYF, QQQQry API's
What DB2 for i interfaces do not use SQE?
300
The IBM STG Lab Services tool thats simplifies Web Query report integration into other applications (making integration a breeze)!!
What is the SOA Toolki?
300
What the restaurant manager purchased to eliminate queuing of the bus boys at the sink (not enough memory)?
What is a bigger sink (more memory)?
300
The recommended length of domain names when creating new DB2 Web Query domains?
What is 8 characters?
300
The name of the ONLY DB2 Web Query adapter that accesses DB2 for i data by generating SQL?
What is DB2 CLI?
400
Up to 10 times as much!
What could a non-IBM i centric enterprise BI tool cost you?
400
The proprietary format that is NOT required by DB2 Web Query to perform Online Analytical Processing.
What are Cubed views?
400
6 hours to 6 seconds
What is a real world (albeit extreme) example of the performance gains that can be achieved by having queries processed by SQE instead of CQE?
400
The DB2 Web Query feature that uses font and/or color in reports to point out and highlight certain conditions that exist with the data.
What is Conditional Styling?
400
The name of the feature in Developer Workbench that allows metadata administrator to break date fields into individual virtual fields (year, quarter, month, day)?
What is Date Decomposition?
500
Summary tables that SQE is aware of and can use instead of the underlying base table(s)?
What are Materialized Query Tables
500
QSYS2/SYSIXADV
What is the name and library of the system table that contains system wide index advice issued by the DB2 optimizer?
500
QAQQINI
What is the DB2 for i query options file that can be used to override default optimizer behavior?
500
The DB2 Web Query option that provide off-line analysis and charting and is ideal for mobile workers
What is Active Reports?
500
File that describes the fields (length and data type) of the data source.