Questions & Answers

Have a question? Ask it here. Or reply and share your knowledge.

TOPICS MEMBERS

Join this category to participate in conversations and receive notifications when new posts are added.

JOIN

Join

0
Filter the values based on the results of other insight
Hi, I am trying to filter on the invoice numbers that are returned by another insight. Is there anyway I can pass the values based on other insight without joining the tables? Example:…
- Swapna ChennamIncorta User
- Starbucks
- schennam
- 7 days ago
- 2 replies
- 20
- Swapna ChennamIncorta User6 hrs ago
- Questions & Answers
0
How to achieve this decode statement
Hi, I want to achieve the below logic in Incorta. DECODE(CODE, NULL, NULL, DATE) Code - Varchar field; Date- Date field If Code is null return null else return date. Thanks,
- Gautham
- Cittabase
- Gautham
- 8 hrs ago
- 1 reply
- 10
- Amit KothariEmployee6 hrs ago
- Questions & Answers
0
How to implement a triple join on a single table
I am trying to figure out how to get a result that comes from a triple self join. I have a table that holds payments with some additional properties about the payment.…
- Marc PaigeIncorta User
- GC Services
- Marc_Paige
- 2 days ago
- 1 reply
- 14
- Amit KothariEmployee2 days ago
- Questions & Answers
1
com.incorta.miniThrift.App cores and memory usage
Good Afternoon, We're trying to better understand what this "com.incorta.miniThrift.App" is running in our Spark applications. In addition, it currently appears to be configured at 8 cores and 2GB…
- Ryan DalyIncorta User
- Gate City Bank
- Ryan_Daly
- 3 days ago
- 1 reply
- 10
- 1
- Shinji YoshidaEmployee3 days ago
- Questions & Answers
0
How does Incorta handle Source deletions of rows ?
How can Incorta support hard deletes in Source System ?
- Amit KothariEmployee
- Incorta
- Amit_Kothari
- 11 mths ago
- 3 replies
- 247
- Amit KothariEmployee3 days ago
- Questions & Answers
0
Most effective way to delete data from a table
Consider a table that is being sourced from Hadoop/Hive named TransactionHistory . The table has a CustomerID field in it, and occassionally a customer is dropped and there is a legal obligation to…
- Dan NielsenIncorta User
- Inmar
- Dan_Nielsen
- 4 days ago
- 1 reply
- 24
- Amit KothariEmployee4 days ago
- Questions & Answers
0
Error while executing a postgres query of incorta tables
Hi, I have been getting the error "Join Structure is not compatible with INCORTA schema definition" when i execute the query on top of the Buisness schema. Please suggest.
- Kiran Chowdary KomatiIncorta User
- Genworth
- Kiran_Chowdary_Komati
- 5 days ago
- 2 replies
- 9
- Amit KothariEmployee5 days ago
- Questions & Answers
0
Using Incorta SDK to connect to Web Services
Hi, I am trying to connect to webservices using Python inside Schema's "Materialized View" But I am running into a problem. It shows the following error: "INC_005002001:…
- peddinti satya sashikanthPartner
- ssit
- peddinti_satya_sashikant
- 6 days ago
- 3 replies
- 17
- Dustin BasilEmployee5 days ago
- Questions & Answers
0
Connecting to SFTP server
Hi, I am having SFTP server having incremental files from which I wish to load the tables. How to achieve this? Questions: How to connect SFTP server using Incorta?…
- Gautham
- Cittabase
- Gautham
- 5 days ago
- 9
- Questions & Answers
0
Unable to Calculate YoY Growth
I have a SQL table with a date column and a metric column (which I want to calculate growth). I joined the main table with date dimension table (date=date).…
- Gautham
- Cittabase
- Gautham
- 13 days ago
- 2 replies
- 22
- Gautham5 days ago
- Questions & Answers
- Answered
- Answered
0
Source DB Table Change, New Fields Added
Can someone provide an update on what happens when a new field is introduced to a table in the Source DB -- and is being synchronized to Incorta? Will Incorta automatically identify the additional…
- William Weils
- MedLever
- William_Weils
- 6 days ago
- 2 replies
- 15
- Dan BrockEmployee5 days ago
- Questions & Answers
0
Date conversion
I have a Date column in my requirement column name is "last_updated" and data format is "January 8, 2018". I need to get this date as "01/08/2018" or "mm/dd/yyyy" Is there any alternate to convert…
- Kondala Rao KandimallaPartner
- Gspann Technologies, inc
- Kondala_Rao_Kandimalla
- 4 mths ago
- 7 replies
- 103
- Dustin BasilEmployee6 days ago
- Questions & Answers
0
Issue while making changes to schema concurrently
Hello everyone, We have been working on Incorta and found out that we won't be able to make changes to schemas concurrently. The latest changes overrides all the previous changes.…
- Kiran Chowdary KomatiIncorta User
- Genworth
- Kiran_Chowdary_Komati
- 7 days ago
- 1 reply
- 17
- Hichem SellamiEmployee6 days ago
- Questions & Answers
0
How to standardize my currency to $xx.xx when the values are not in this format in the schema or they are imported from source as integers?
- Fahim
- Inmar
- Fahim
- 7 days ago
- 10
- Questions & Answers
0
Unable to connect MySQL data source
Hi, I'm unable to connect to MySQL data source .I'm able to connect to MySQL workbench but not in Incorta. I'm getting below error message : INC_005002001:…
- Sandhya RaniPartner
- Quest Global
- Sandhya_Rani
- 10 days ago
- 4 replies
- 13
- Dan BrockEmployee10 days ago
- Questions & Answers
0
ways to restrict data
Is there a way to restrict data at table level across schema. say example. i have 500 tables spread across 100 schemas, how do i limit the data for all tables across one shot.…
- RamIncorta User
- wipro
- Ram
- 4 wk ago
- 7 replies
- 62
- Mazen ArarEmployee12 days ago
- Questions & Answers
0
How do I create a variance column from two filtered columns?
Hello, In the attached image, we have two filtered columns, "Actual - 2019" and "Forecast April - 2019", I want to add a "Variance" column, which is the difference between the two columns.…
- Kevin JacklinIncorta User
- Civeo
- Kevin_Jacklin
- 3 wk ago
- 5 replies
- 37
- Kevin JacklinIncorta User13 days ago
- Questions & Answers
- Answered
- Answered
0
Unable to connect to IncortaMetadata outside the server through DBVizsualizer
I am unable to connect to IncortaMetadata outside the server(from local machine), Is there any setting or configuration to change to do the same.
- Gnaneshwar MuthaluriIncorta User
- genworth
- Gnaneshwar_Muthaluri
- 2 wk ago
- 3 replies
- 14
- Patrick RaffertyEmployee2 wk ago
- Questions & Answers
- Answered
- Answered
0
Schema load finished with errors
when i load data from tables by (load now -> Full ) i get errors with the messages say : IO Error: Failed to create/update PK index for table Pleas help.
- Ahmed Omar
- Crystal
- Ahmed_Omar
- 2 wk ago
- 2 replies
- 15
- Ahmed Omar2 wk ago
- Questions & Answers
0
Visualization Requirements
Team, Can we configure Incorta UI in order to do some of the following display in my dashboard 1. Can we use any sort of tags to bold the characters 2.…
- SrinivasPartner
- Wipro Technologies
- Srinivas
- 2 wk ago
- 1 reply
- 26
- Danish KhanEmployee2 wk ago
- Questions & Answers
0
Row Level Security and Aggregation
We're looking for best practices and recommendations on how to implement RLS, while also allowing for aggregations to occur at higher levels. Does Incorta support such scenarios?
- Ryan DalyIncorta User
- Gate City Bank
- Ryan_Daly
- 2 wk ago
- 1 reply
- 26
- Amit KothariEmployee2 wk ago
- Questions & Answers
0
Using Tosca with Incorta
To Incorta folks or anyone in the community...anyone hear of utilizing Tosca BI with Incorta to assist with validation?
- Kelly Genova
- Genworth Financial
- Kelly_Genova
- 3 wk ago
- 1 reply
- 8
- Dan BrockEmployee3 wk ago
- Questions & Answers
0
MV Spark loop failing
Good Day Community, I'm working to build a historic table by looping through a SQL statement, translated into Python/Spark. Everything works, including being able to union two or more resulting…
- Ryan DalyIncorta User
- Gate City Bank
- Ryan_Daly
- 3 wk ago
- 5 replies
- 26
- Ryan DalyIncorta User3 wk ago
- Questions & Answers
0
How to export Dashboards as .xml
- Ahmed EltanahyEmployee
- Incorta
- Ahmed_Eltanahy
- 1 yr ago
- 5 replies
- 80
- Dan BrockEmployee3 wk ago
- Questions & Answers
- Answered
- Answered
0
Spark Materialized Views & Memory
I am using a Materialized View to join two tables together and create a single merged result. The basic PySpark code I'm using is: from pyspark.sql import SparkSession df1 = read("ClaimRepoDemo.…
- Dan NielsenIncorta User
- Inmar
- Dan_Nielsen
- 10 mths ago
- 9 replies
- 594
- Amit KothariEmployee3 wk ago
- Questions & Answers
- Answered
- Answered

1 2 3 4 5 13 Next

Have a question? Ask it here. Or reply and share your knowledge.

Members

View members

Get Help

Product Documentation

Questions & Answers

Filter the values based on the results of other insight

How to achieve this decode statement

How to implement a triple join on a single table

com.incorta.miniThrift.App cores and memory usage

How does Incorta handle Source deletions of rows ?

Most effective way to delete data from a table

Error while executing a postgres query of incorta tables

Using Incorta SDK to connect to Web Services

Connecting to SFTP server

Unable to Calculate YoY Growth

Source DB Table Change, New Fields Added

Date conversion

Issue while making changes to schema concurrently

How to standardize my currency to $xx.xx when the values are not in this format in the schema or they are imported from source as integers?

Unable to connect MySQL data source

ways to restrict data

How do I create a variance column from two filtered columns?

Unable to connect to IncortaMetadata outside the server through DBVizsualizer

Schema load finished with errors

Visualization Requirements

Row Level Security and Aggregation

Using Tosca with Incorta

MV Spark loop failing

How to export Dashboards as .xml

Spark Materialized Views & Memory

Members

Get Help

More

Tags

Home

Tags