Learn

Docs

Support

How to enable Javascript

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
2nd Level aggregate on specific groups
I have a requirement which needs aggregation to be applied, on aggregated data, on specific groups. Something similar to the pseudo-SQL statement below.…
- Naresh KumarPartner
- Pramati Technologies
- Naresh_Kumar
- 4 mths ago
- 8 replies
- 49
- Matthew HallidayEmployee4 mths ago
- Questions & Answers
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
- 4 mths ago
- 3 replies
- 26
- Dan BrockEmployee4 mths ago
- Questions & Answers
0
Incremental Query visibility
I am having some incremental load issues and would like to see the actual query used. Is it available in the audit somewhere? I am trying to triage the issue before resorting to a support ticket.
- Marc PaigeIncorta User
- GC Services
- Marc_Paige
- 4 mths ago
- 4 replies
- 35
- Marc PaigeIncorta User4 mths ago
- Questions & Answers
0
Loader Service getting stopped automatically when trying to load any shema.
Hi We are using Incorta version 4.4 and there is one issue that we are facing that whenever we are trying to load any schema ,Loader service is getting automatically stopped.…
- harshPartner
- wipro
- harsh
- 4 mths ago
- 1 reply
- 27
- Hichem SellamiEmployee4 mths ago
- Questions & Answers
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
- 6 mths ago
- 6 replies
- 66
- harshPartner4 mths ago
- Questions & Answers
0
Exception for Tables Not Populating
Is there a way to trigger an exception or e-mail if a specific table does not populate data when refreshed?
- Mark SamuelsIncorta User
- Shutterfly
- Mark_Samuels
- 4 mths ago
- 4 replies
- 26
- Joe SteinbrunnerIncorta User4 mths ago
- Questions & Answers
0
Business Days Between
Hi everyone, sorry if this has been asked before (I've searched the forum and documentation and can't find a solution). I have a need to be able to calculate business days between two dates…
- Sam
- Zeus
- Sam
- 4 mths ago
- 3 replies
- 62
- Sam4 mths ago
- Questions & Answers
- Answered
- Answered
0
How to show Hierarchy eg Sr manager->Manager->Asstt Manager->Employee for data Drill Purpose
Can someone guide me how to create Hierarchy in Incorta 3.5. For example : I need details of all Sr managers, right from top level up to bottom level. Sr manager->Manager->Asstt Manager->Employee…
- DelliIncorta User
- Keysight
- Delli
- 10 mths ago
- 7 replies
- 127
- Joe SteinbrunnerIncorta User4 mths ago
- Questions & Answers
0
How to load a missing snapshot day
Patching caused the loader to be delayed and a scheduled incremental load of a snapshot for a table was missed. Is there a way to load the missing day into that table?
- Marc PaigeIncorta User
- GC Services
- Marc_Paige
- 4 mths ago
- 2 replies
- 30
- Marc PaigeIncorta User4 mths ago
- Questions & Answers
- Answered
- Answered
0
How I get more info on an incremental data load error of "Not Completed"?
Hello, I executed an incremental data load that ran for 67 minutes. It finished with an error status, and the message is "Not Completed", however, the Job Details suggest every table loaded.…
- Kevin JacklinIncorta User
- Civeo
- Kevin_Jacklin
- 4 mths ago
- 2 replies
- 30
- Kevin JacklinIncorta User4 mths ago
- Questions & Answers
- Answered
- Answered
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
- 10 mths ago
- 9 replies
- 248
- Anurag MalikEmployee4 mths ago
- Questions & Answers
0
its pyspark create dataframe from list of lists
I have list of lists input alert_highlightsa = [('AML3665823', [('AML-MAS', 'AML-MAS-ALL-ALL-A-M01-MAS', 'Manual Alert Created by Joanne Cegielski', 'Party Group', 'AML3665823', 'N/A', 'N/A',…
- Geetha Boggarapu
- wipro
- Geetha_Boggarapu
- 4 mths ago
- 1 reply
- 42
- Subba Jevisetty4 mths ago
- Questions & Answers
0
unable to connect MS SQL server in incorta
Hi Team, Please help we are trying to add new data source in our incorta system. when we try to connect getting "Driver:SQLServerDriver:9 returned null " error and it is working fine in SQL…
- DelliIncorta User
- Keysight
- Delli
- 5 mths ago
- 8 replies
- 87
- DelliIncorta User4 mths ago
- Questions & Answers
- Answered
- Answered
0
Implement 'OR' function in prompts or filters
Hi, How do we implement 'OR' function in the prompt or filter section? Example HTS Number 1 begins with <prompt> Or HTS Number 2 begins with <prompt> Or HTS Number 3 begins with <prompt> Or HTS…
- Swapna ChennamIncorta User
- Starbucks
- schennam
- 4 mths ago
- 1 reply
- 24
- Dan BrockEmployee4 mths ago
- Questions & Answers
0
How many times can the ? be used in an incremental SQL?
I have a rather complicated SQL for a table that compares timestamps 3 times in the query. Can I use the ? in all three places?
- Marc PaigeIncorta User
- GC Services
- Marc_Paige
- 5 mths ago
- 1 reply
- 35
- Amit KothariEmployee5 mths ago
- Questions & Answers
- Answered
- Answered
2
How do I create a Slowly Changing Type 2 (SCD) Dimension?
Please show me how to create a Slowly Changing Type 2 (SCD) Dimension where I can track the changes for few fields in a Customer table?
- Amit KothariEmployee
- Incorta
- Amit_Kothari
- 5 mths ago
- 1 reply
- 50
- 2
- Amit KothariEmployee5 mths ago
- Questions & Answers
- Answered
- Answered
0
how to show total
I have a data as below, I need to show a max of all numbers throughout all the columns, how can I achieve this incorta Teams score total Team 1 30 90 Team 2 36 90 Team 3 42 90 Team 4 48 90 Team 5 54…
- venkatRaoIncorta User
- Broadcom
- Rao
- 1 yr ago
- 7 replies
- 221
- Ramaraju Hema KavithaPartner5 mths ago
- Questions & Answers
0
Unable to query the data from table through MV
Hi Folks, When i am trying to load a table from MV, I am facing attached Error. Can any one know this error? please help me. Example: select ACCOUNTING_EVENT_ID from AP_INVOICE_DISTRIBUTIONS_ALL…
- vishnuPartner
- infosy
- vishnu
- 5 mths ago
- 8 replies
- 49
- vishnuPartner5 mths ago
- Questions & Answers
0
schema load status alert
Hi, How to create IncortaMetadata schema using Incorta Metadata source?
- Sandhya RaniPartner
- Quest Global
- Sandhya_Rani
- 5 mths ago
- 4 replies
- 53
- Dustin BasilEmployee5 mths ago
- Questions & Answers
2
Trigger a Incorta Load through a script or similar
We have an external scheduling tool from which can run shell/cmd scripts on a machine.. we want to trigger an incorta job load using this tool (Appworx,…
- Gnaneshwar MuthaluriIncorta User
- genworth
- Gnaneshwar_Muthaluri
- 7 mths ago
- 9 replies
- 139
- 2
- Dhanraj PalaniIncorta User5 mths ago
- Questions & Answers
- Answered
- Answered
0
Boolean Data Type in Schema
When importing data in a Schema, I've noticed there is no data type for boolean or bit available. I know this is a simple question but have not seen any documentation, questions,…
- Joe SteinbrunnerIncorta User
- Inmar
- Joe_Steinbrunner
- 5 mths ago
- 3 replies
- 33
- Amit KothariEmployee5 mths ago
- Questions & Answers
- Answered
- Answered
0
NULL date value in formula
I'm trying to add a formula column on a table that will convert a date string to a date. The string is always formatted "mm/dd/yyyy" *but* there are some rows that have "00/00/0000" or "01/01/1900"…
- Dan NielsenIncorta User
- Inmar
- Dan_Nielsen
- 5 mths ago
- 9 replies
- 110
- Ramaraju Hema KavithaPartner5 mths ago
- Questions & Answers
0
INVALID FORMULA Error when using CASE with Aggregation
Hi All I have data like below Item Quarter TotalCost Item1 FY19 Q4 100 Item1 FY20 Q1 120 The Total Cost Column is a Formula column from Business Schema and has some further calculations behind it.…
- Yogesh BhavePartner
- Infosys Ltd
- Yogesh_Bhave
- 5 mths ago
- 3 replies
- 44
- Yogesh BhavePartner5 mths ago
- Questions & Answers
0
Remove Byte Order Mark in CSV export
We have a couple dashboards we use to export a CSV from to be consumed by some internal systems. In some cases, we are seeing a BOM in the exports but it seems inconsistent.…
- Tom FogartyIncorta User
- Inmar
- Tom_Fogarty
- 5 mths ago
- 4 replies
- 20
- Dustin BasilEmployee5 mths ago
- Questions & Answers
0
Search Box is not working with Formula created in Prompts Section
Hi Team, I have created one Formula in Prompts section of my dashboard by concat two different DB columns "School_ID" & "School_Name" and kept the Formula name as "School_Details".…
- RudraIncorta User
- Quest Global
- Rudra
- 5 mths ago
- 16
- Questions & Answers

1 2 3 4 5 17 Next

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

Members

View members

Get Help

Product Documentation

Questions & Answers

2nd Level aggregate on specific groups

Using a Business View to Update a Historical Table

Incremental Query visibility

Loader Service getting stopped automatically when trying to load any shema.

Schema load finished with errors

Exception for Tables Not Populating

Business Days Between

How to show Hierarchy eg Sr manager->Manager->Asstt Manager->Employee for data Drill Purpose

How to load a missing snapshot day

How I get more info on an incremental data load error of "Not Completed"?

Date conversion

its pyspark create dataframe from list of lists

unable to connect MS SQL server in incorta

Implement 'OR' function in prompts or filters

How many times can the ? be used in an incremental SQL?

How do I create a Slowly Changing Type 2 (SCD) Dimension?

how to show total

Unable to query the data from table through MV

schema load status alert

Trigger a Incorta Load through a script or similar

Boolean Data Type in Schema

NULL date value in formula

INVALID FORMULA Error when using CASE with Aggregation

Remove Byte Order Mark in CSV export

Search Box is not working with Formula created in Prompts Section

Members

Get Help

More

Tags

Home

Tags