How to enable Javascript

Latest Posts

Re: Log Retention Okay, thank you. I just wanted to make sure there wasn't something already existing before I created it. On a side node I ran into a permission problem with the catalina log file rotation.…
- Ryan SatherIncorta User
- Gate City Bank
- Ryan_Sather
- 3 wk ago
- Questions & Answers
- Reported - view
1
Log Retention
Is there a global setting for log retention for all of the various logs under the analytics and loader services?
- Ryan SatherIncorta User
- Gate City Bank
- Ryan_Sather
- 3 wk ago
- 4 replies
- 20
- 1
- Questions & Answers
Re: Limit for SQL statement size with Incremental Load? Hi @Ahmed Moawad . I first noticed it on 4.5.9 but I was never able to figure out why the selection would work sometimes but not others. We are now on version 4.6.
- Ryan SatherIncorta User
- Gate City Bank
- Ryan_Sather
- 1 mth ago
- Questions & Answers
- Reported - view
0
Limit for SQL statement size with Incremental Load?
I'm having a strange issue while configuring incremental loads on a table with a large number of fields (280). If I paste the SELECT statement that lists all of the fields individually with the…
- Ryan SatherIncorta User
- Gate City Bank
- Ryan_Sather
- 1 mth ago
- 3 replies
- 14
- Questions & Answers
1
HOWTO: Unpivot a table with python
Related to the pivoting of data I also needed to find a good way to unpivot data, specifically from the census data. The data comes with age groups in separate columns: Year, State, City, Under_5,…
- Ryan SatherIncorta User
- Gate City Bank
- Ryan_Sather
- 2 mths ago
- 1 reply
- 18
- 1
- Questions & Answers
0
Load Order - Extract and Load Question
Incorta 4.5.9 We have a schema where a table in the schema is loaded from a table in the same schema so I have set the load order for the second table to load after the first table.…
- Ryan SatherIncorta User
- Gate City Bank
- Ryan_Sather
- 2 mths ago
- 22
- Questions & Answers
1
HOWTO: Pivot a table with python
I have worked on finding a good way to pivot data and have finally settled on a method that works really well. One benefit of this is if new fields are added it automatically creates the additional…
- Ryan SatherIncorta User
- Gate City Bank
- Ryan_Sather
- 2 mths ago
- 23
- 1
- Questions & Answers
0
Uploaded data file via sftp - Not showing up in list unless refreshed by Super User
We are working on an automated system for uploading data files and the upload is working correctly. The problem we are having is that the any new files won't show up under Data Files in the…
- Ryan SatherIncorta User
- Gate City Bank
- Ryan_Sather
- 2 mths ago
- 1 reply
- 17
- Questions & Answers
Re: Using a Business View to Update a Historical Table Hi Dan Thanks for the reply. Yes, that is essentially what I'm doing now and it's working. My question is more of if there is a better way or a reason I shouldn't do that.…
- Ryan SatherIncorta User
- Gate City Bank
- Ryan_Sather
- 5 mths ago
- Questions & Answers
- Reported - view
0
Using a Business View to Update a Historical Table
How bad of an idea is it to use a business schema as a source for a historical table in schema? We have a requirement to keep a snapshot of customer data on a monthly basis.…
- Ryan SatherIncorta User
- Gate City Bank
- Ryan_Sather
- 5 mths ago
- 3 replies
- 31
- Questions & Answers

Back to top

Incorta User

Ryan Sather

Ryan_Sather

Gate City Bank

Fargo, ND

11
5
0

Follow