How to enable Javascript

Latest Posts

Re: Customizing logo and background Image by Creating/Modifying Custom CSS File @Mike Mascitti Nevermind - clearing my cache fixed it!
- Mike MascittiIncorta User
- Northwestern Mutual
- Mike_Mascitti
- 7 days ago
- Help Articles
- Reported - view
Re: Customizing logo and background Image by Creating/Modifying Custom CSS File Hello, I've tried these modifications, but the only one that works is the changing of the banner color. Changing the logo or adding text hasn't worked.…
- Mike MascittiIncorta User
- Northwestern Mutual
- Mike_Mascitti
- 8 days ago
- Help Articles
- Reported - view
0
How to link insights from different sources using a common filter?
Hello, I'm trying to link insights together so they filter on the same key, but the insights have different sources. For example: one insight is based off a business schema with a few select fields…
- Mike MascittiIncorta User
- Northwestern Mutual
- Mike_Mascitti
- 12 days ago
- 5 replies
- 13
- Questions & Answers
Re: Upsert for Incremental Loading @joseph. delpercio To answer your question above... Whatever field(s) you label as 'Key' in the load details tell Incorta how to define a unique row. If you load a row in Incremental load that has…
- Mike MascittiIncorta User
- Northwestern Mutual
- Mike_Mascitti
- 5 mths ago
- Questions & Answers
- Reported - view
Re: Upsert for Incremental Loading If I understand correctly, it sounds like you want to pull new rows without having a timestamp or anything that helps identify them as new. If you can't put something in the query to only pull new…
- Mike MascittiIncorta User
- Northwestern Mutual
- Mike_Mascitti
- 5 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Upsert for Incremental Loading Hi Joseph - you can do this with a SQL hashbytes function. It allows you to pick whatever fields you want and creates a hash key out of them. Then just make the HashKey the primary Key on the…
- Mike MascittiIncorta User
- Northwestern Mutual
- Mike_Mascitti
- 5 mths ago
- 1
- Questions & Answers
- Reported - view
Re: How do you join tables loaded incrementally? Hi Amit, thanks for the response. I initially added date as part of the key because the document I found (linked above) on creating sparse snapshots had step 2 as 'create keys on last_modified_date…
- Mike MascittiIncorta User
- Northwestern Mutual
- Mike_Mascitti
- 10 mths ago
- Questions & Answers
- Reported - view
0
How do you join tables loaded incrementally?
Hello, as a new user I'm hoping there's a standard recommended approach to this. When tables are loaded incrementally they use a Last Modified Date (or hash key) to only load new or changed rows to…
- Mike MascittiIncorta User
- Northwestern Mutual
- Mike_Mascitti
- 10 mths ago
- 3 replies
- 51
- Questions & Answers
Re: Incremental load Hi Dan, thanks for the response. I've tried the following and gotten a couple different errors. In your example, when I do this in an incremental load...…
- Mike MascittiIncorta User
- Northwestern Mutual
- Mike_Mascitti
- 11 mths ago
- Questions & Answers
- Reported - view
Re: Incremental load Hello, I've got the same question as the original post. From the above responses, it looks like it's possible, but 'how' is it done? In my example I'd have a field (called CheckSum) that would…
- Mike MascittiIncorta User
- Northwestern Mutual
- Mike_Mascitti
- 11 mths ago
- Questions & Answers
- Reported - view

Back to top

Incorta User

Mike Mascitti

Mike_Mascitti

Northwestern Mutual

Senior Engineer

Milwaukee, WI

10
2
1

Follow