How to enable Javascript

Queries

3
How does the Max Groups Parameter work?
Some queries can create very large results that may impact the working memory of the server. This is the case for queries with multiple nested groups. To avoid the server running out of memory…
- Matthew HallidayEmployee
- Incorta
- Matthew_Halliday
- 2 yrs ago
- 1 reply
- 457
- 3
- DylanEmployee8 days ago
- Questions & Answers
- Answered
- Answered
1
Explaining Base Tables
Because Incorta can accommodate 3NF design, there is commonly more than one "path" by which we can link two tables together. Take, for example, the schema above.…
- 4 mths ago
- 743
- 1
- Help Articles
0
How to perform update/delete in materialized view
I have created an MV with complex logic involving large tables and aggregate functions. As part of a new request, I need to update/delete certain records as well as change column data type.…
- Gautham
- Cittabase
- Gautham
- 6 mths ago
- 1 reply
- 19
- Dan BrockEmployee6 mths ago
- Questions & Answers
0
Convert Binary Code
My team and working with AS400 data and we need to know how to convert binary data (CCSID 65535) becuase we aren't getting this data when we try to query.…
- joseph. delpercio
- Scientific Games
- joseph_delpercio
- 8 mths ago
- 5 replies
- 16
- joseph. delpercio7 mths ago
- Questions & Answers
- Answered
- Answered
0
AS400 DB2 Date value as timestamp
Hey All, I have a DB2 system that has time and date in a different column, is there a way to put them together or just use date as the timestamp to load through as an incremental?
- joseph. delpercio
- Scientific Games
- joseph_delpercio
- 8 mths ago
- 6
- Questions & Answers
0
Error while adding one specific column to MV
Hi, I am seeing the attached error when I am trying to add one specific column to the MV. When I drag and drop that column directly from the base table to the insight,…
- Swapna ChennamIncorta User
- Starbucks
- schennam
- 1 yr ago
- 30
- Questions & Answers
0
How to call a stored procedure in Incorta
I have created a stored procedure which doesn't take any inputs but simply returns a table in SQL server. I am unable to call this procedure to load the data in one of the tables in Incorta which is…
- Nikitha NimbalkarIncorta User
- Valetliving
- Nikitha_Nimbalkar
- 1 yr ago
- 6 replies
- 186
- Marc PaigeIncorta User1 yr ago
- Questions & Answers
2
Installing Incorta with a queryable Derby database
Introduction: The purpose of this article is to detail the steps necessary to connect to the Incorta Derby database and use the tenant management tool (tmt) at the same time without having to stop…
- 1 yr ago
- 137
- 2
- Help Articles

Back to top

Recent activity

Tags

Top contributors

View all members