Incorta
Community
Learn
Docs
Support
How to enable Javascript
Login
Sign Up
Login
Search
Home
Tags
Queries
Filter
Active
Newest
Popular
Most likes
Most replies
Most views
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 Halliday
Employee
Incorta
Matthew_Halliday
2 yrs ago
1
reply
457
3
Dylan
Employee
8 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 Brock
Employee
6 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. delpercio
7 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 Chennam
Incorta 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 Nimbalkar
Incorta User
Valetliving
Nikitha_Nimbalkar
1 yr ago
6
replies
186
Marc Paige
Incorta User
1 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
Recent activity
Tags
View all tags
Top contributors
View all members
Login
Sign Up
Home
Community
Questions & Answers
Events
Knowledge Base
Product Announcements
Learn
Help Articles
Product Videos
Introduction to Incorta (17 Videos)
How To Videos
Tags
View all tags
Product Announcement
Incorta 4.9
is now Generally Available (GA)!!!