Operations-Related Options for Genesys Info Mart

Genesys Info Mart behavior and functionality are controlled by configuration option settings on the Genesys Info Mart Application and other supporting objects, such as DNs and Scripts.

The tables on this page list the configuration options that affect the operations of the Genesys Info Mart components. These options control the ETL process, and most of them apply in any environment. The tables group the options by functional area.

Review the options to identify the ones that are relevant to the Genesys Info Mart operation in your environment. In particular, decide:

• For new deployments, from which date you want Genesys Info Mart to start extracting data after the Info Mart database is initialized (see Startup)
• How you want Genesys Info Mart to schedule launching of ETL jobs (see Scheduling)
• How you want Genesys Info Mart to process error conditions during data transformation (see Transformation error handling)
• What logging level is sufficient for Genesys Info Mart Server (see Logging)
• How you want to adjust ETL behavior to meet requirements for data quality and data availability, given the characteristics of your environment and interaction flows (see Miscellaneous)
• Which, if any, of the redundant IDBs in an HA set you want to identify as preferred for the purposes of extraction (see Miscellaneous)
• How you want Genesys Info Mart to optimize Genesys Info Mart Server performance (see Performance tuning)
• What data-retention policies and other purge-related strategies you want to implement (see Database maintenance)
• What calendar dimensions you need for your reports (see Calendar maintenance)

Related Information

In addition to the operations-related options on this page, you might be interested in the following:

• Data-Processing Options for Genesys Info Mart — Affect the content and quality of data that is stored in the Info Mart database.
• Genesys Info Mart Aggregation-Related Options for GI2 and RAA — Enable aggregation in your deployment, if GI2 or RAA is installed.

Operations-Related Options Summary Tables

The following tables summarize the Genesys Info Mart operations-related options:

• Startup
• Scheduling
• Transformation error handling
• Logging
• Miscellaneous
• Performance tuning
• Database maintenance
• Calendar maintenance

Tip

Click an option name in a table to see a short description, from which you can link directly to the option description in the Genesys Info Mart Configuration Options Reference.

Startup

Configuration Object	Section Name	Option Name and Default Value	Comments
Genesys Info Mart Application	[gim-etl]	No results=Initialization date minus 30 days	In the Application object, configure the options on the Options tab.

Back to List of Tables

---

Scheduling

Configuration Object	Section Name	Option Name and Default Value	Comments
Genesys Info Mart Application	[schedule]	No results=GMT No results=false No results=1 No results=06:00 No results=22:00 No results=false No results=0 1 No results=5:00 No results=true No results=03:00 No results=false No results=0/10 *	In the Application object, configure the options on the Options tab.

Back to List of Tables

---

Transformation error handling

Configuration Object	Section Name	Option Name and Default Value	Comments
Genesys Info Mart Application	[error-policy]	No results=resume No results=exception No results=resume No results=resume No results=resume No results=resume No results=resume No results=resume No results=resume No results=resume No results=resume No results=log_db_resume No results=Exception	In the Application object, configure the options on the Options tab.

Back to List of Tables

---

Logging

Configuration Object	Section Name	Option Name and Default Value	Comments
Genesys Info Mart Application	[log4j]	log4j.appender.ConsoleLogger.Threshold=info No results=info No results=gim_etl.log No results=50MB No results=10 No results=%d{ISO8601} %-5p %-12t %m%n No results=%d{ISO8601} %-5p %-12t %m%n	In the Application object, configure the options on the Options tab.
	[log]	No results=standard No results=network

Back to List of Tables

---

Miscellaneous

Configuration Object	Section Name	Option Name and Default Value	Comments
Genesys Info Mart Application	[gim-etl]	No results=900 No results=28860 No results=3600 No results=30 No results=0 No results=0 No results=3600	Note: The primary purpose of these options is to control aspects of Genesys Info Mart behavior that affect data quality or data availability. However, these options also have an impact on operating performance (for example, because they influence the size of merge tables or staging tables). In the Application object, configure the options on the Options tab.
	[gim-transformation]	No results=1	In the Application object, configure the option on the Options tab.
Info Mart and extraction DAPs	[gim-etl]	No results=“”	In the DAP object, configure the option on the Options tab.

Back to List of Tables

---

Performance tuning

Configuration Object	Section Name	Option Name and Default Value	Comments
Genesys Info Mart Application	[gim-etl]	No results=90000 No results=900 No results=128 No results=32 No results=10 No results=200000	In the Application object, configure the options on the Options tab.
	[gim-transformation]	No results=4 No results=5

Back to List of Tables

---

Database maintenance

Configuration Object	Section Name	Option Name and Default Value	Comments
Genesys Info Mart Application	[gim-etl]	No results=14 No results=400 or days-to-keep-gim-facts No results=400 No results=30 No results=2 No results=600 No results=100000 No results=32 For partitioned databases only: No results=86400 No results=86400 No results=86400 No results=86400 No results=14	In the Application object, configure the options on the Options tab.

Back to List of Tables

---

Calendar maintenance

Configuration Object	Section Name	Option Name and Default Value	Comments
Genesys Info Mart Application	[date-time] For custom calendars: [date-time-*]	No results=DATE_TIME No results=GMT No results=2012 No results=183 No results=366 No results=true No results=1 No results=1 No results=none No results=	In the Application object, configure the options on the Options tab.

Back to List of Tables

---