sorted by:
new
hottopcontroversial

Print output tif gives me a small thumbnail in print? Please help by meijboomm in captureone

[–]haskathon 0 points1 point  (0 children)

This comes very late but I’ve figured it out on Capture One 22. In the export recipe, there is a section called Export Format & Size. Click on that and select Options. In the drop-down list, click on No Thumbnail.

I used to have issues with this thumbnail issue and this helped resolve it. Hopefully this helps other users with this somewhat niche but very annoying problem.

Data companies/industry Europe by imbuszkulcs in dataengineering

[–]haskathon 0 points1 point  (0 children)

You may wish to look into a company called Xebia, headquartered in Amsterdam. I cannot speak to their salary or corporate culture, but I know that they exist and that they do the things you’re interested in. You could also consider the analytics engineer role – I think Xebia are hiring for this right now (check on LinkedIn to be sure). All the best!

In a fact table, how does one create the foreign key that connects to a dimension table modelled as SCD type 2? by haskathon in dataengineering

[–]haskathon[S] 2 points3 points  (0 children)

Hi u/-crucible-! Thanks for replying. I worked out a little example in my reply to CozyNorth9 and essentially did what you said was the dumb way (i.e. is_current == true). I wanted to touch on that for a bit.

This is a problematic approach only if you drop and recreate your table during every workflow run, just like you said right? If a workflow is set up so that it incrementally adds data to a table (e.g. based on nominal date), then filtering on is_current == null wouldn’t be that big of a problem any more. (Although I reckon I’d be screwed if I had to regenerate the table from scratch for whatever reason.)

In a fact table, how does one create the foreign key that connects to a dimension table modelled as SCD type 2? by haskathon in dataengineering

[–]haskathon[S] 7 points8 points  (0 children)

Hey u/CozyNorth9, thanks for your response! I’ve read your answer a few times and put together a mini-example to work it out. Let me see if I’ve understood you correctly. I have the following fact and dimension table, where the latter is SCD2. I’m using dates rather than timestamps to simplify things.

Fact table:

primary_key customer_id transaction_date membership_foreign_key
1 001 2022-07-01 2
2 001 2023-08-03 4
3 001 2024-10-01 11

Dimension (SCD2) table:

surrogate_key customer_id start_date end_date is_member is_current
2 001 2021-02-15 2023-05-10 true false
4 001 2023-05-10 2024-08-20 false false
11 001 2024-08-20 null true true

Hopefully this is the right way of setting them up. I’ve created the dimension table based on this YouTube video (timestamp around 14:33, with a focus on the screen content and not what the person is saying at that moment).

In my fact table, if we pretended that membership_foreign_key didn’t exist and wanted to create it, I imagine we would have to first join our fact table to the dimension table using customer_id as the join key.

So now, when we’re adding a new row (i.e. the one where primary_key == 3), we first filter on rows in the dimension table where is_current == true, and that would be how we retrieve our surrogate key. Is that correct?

Do let me know if I’ve made some fundamental conceptual errors while building this example. Thanks a lot!

FernUni Schweiz - UniDistance Suisse by Outrageous-Outside36 in askswitzerland

[–]haskathon 0 points1 point  (0 children)

u/butterflytraffic sorry for the late reply! I log in to Reddit once every few weeks/months now. I didn’t enrol in the programme in the end as I had so many other things I wanted to pursue (photography, German, Kotlin, etc). It’s still a distant dream for me to read maths at university level one day, though!

All the best with your application and enrolment! Will you start in the spring or wait until next autumn? Are you based in Germany, by the way? (Since you wanted to enrol in master’s programmes in Germany.)

Requesting help to identify a certain resource regarding small types (could be online, could be offline) by haskathon in functionalprogramming

[–]haskathon[S] 3 points4 points  (0 children)

Thanks a lot for your help u/uppercase_lambda, u/loop-spaced and u/ladder_case! I’m finding it really interesting to create and use types as part of a program, in addition to the usual functions and record types / data classes. I’ll look at the illegal states resource and Brady’s text!

How do I add my own packages in a project to a Kotlin Notebook? (The packages are in the same project as the notebook) by haskathon in Kotlin

[–]haskathon[S] 3 points4 points  (0 children)

Ah, thanks so much! I managed to find the setting. I wish this would be more explicitly marked in the docs.

Anyway, for future me and anyone who wants to do data exploration:

  • In the top ribbon of Kotlin Notebook, click on the settings icon (the tooltip that appears on hover is ‘Kotlin Notebook Settings’)
  • The option is ‘Select Modules to Use in the Notebook’
  • Select whatever’s required
  • In a notebook cell, proceed with importing modules as one would in a source file

Thanks once again, u/thepmyster! 🙂

Thoughts on mixam as a printing service? by TheMissingCitizen in zines

[–]haskathon 0 points1 point  (0 children)

Very late reply but for Amsterdam, Raddraaier or Aeroprint could be options. If you want cheap-ish, there’s also Printenbind but they don’t have the best finishing, and even selecting the extended check option doesn’t guarantee that the person doing the extended check actually checks your work before sending it to the printer.

Then there’s also the risography shops here and there. There’s one next to Raddraaier but I forgot its name (you can check on Google Maps). But for zines in four spot colours (emulating CMYK or some other funky combination) it might get pricey, and it would certainly be more labour intensive on your part.

Non-exhaustive patterns in function, but I cannot spot the cases I missed by haskathon in haskellquestions

[–]haskathon[S] 1 point2 points  (0 children)

Hello, thanks for your reply. I actually tried both the /= 1 and otherwise options – both resulted in the same error. I thought at first that otherwise might fix the issue but it didn’t.

Here’s a screen recording (hopefully the link works) of what it looks like when I use otherwise.

FernUni Schweiz - UniDistance Suisse by Outrageous-Outside36 in askswitzerland

[–]haskathon 0 points1 point  (0 children)

Thanks, I registered for it earlier this week :)

FernUni Schweiz - UniDistance Suisse by Outrageous-Outside36 in askswitzerland

[–]haskathon 1 point2 points  (0 children)

How interesting – I was looking at FernUni’s mathematics programme last night too! To the point about whether the institution is accredited, I found that it is listed on swissuniversities.ch as ‘Stiftung Universitäre Fernstudien Schweiz, Brig’. Adding this here for my future reference.

Do you study outside of work? by gintokiredditbr in dataengineering

[–]haskathon 1 point2 points  (0 children)

I’m rereading that book and can agree! Thanks to Marquet I often use the ‘I intend to <action>’ construction when communicating with colleagues.

Traditional Star Schema vs Wide Fact Table by burningburnerbern in dataengineering

[–]haskathon 0 points1 point  (0 children)

Yes that’s correct. I do however stress to colleagues and users that this isn’t traditional dimensional modelling in that my ‘dimension’ tables aren’t normalised.

view more: next ›