Recently, while working at a customer site and I encountered an anomaly in the Netezza Connector stage, when choosing ‘User-defined SQL’ write mode, the ‘Table name’ displays a caution/warning even though a table name should not be required. If you are using a user-defined SQL statement and/or have parametrized your SQL scripts to make the job reusable, each SQL and/or SQL script would have its own schema and table name being passed in. After some investigation, a workaround was found, which both allows you to populate table name and leverage with different schema and table names within your SQL statement and/or. Table …
Tag
Showing: 1 - 2 of 2 RESULTS
PureSystems
Data Warehouse – Effective Practices
Effective Practices Effective practices are enablers, which can improve performance, data availability, environment stability, resource consumption, and data accuracy. Use of an Enterprise Scheduler The scheduling service in InfoSphere Information Server (IIS) leverages the operating system (OS) scheduler, the common enterprise scheduler can provide these capabilities beyond those of a common OS scheduler: Centralized control, monitoring, and maintenance of job stream processes Improved insight into and control of cycle processes Improved intervention capabilities, including alerts, job stream suspension, auto-restarts, and upstream/downstream dependency monitoring Reduced time-to-recovery and increased flexibility in recovery options Improved ability to monitor and alert for a mission-critical …