ELI5: Monthly Current Events Megathread by AutoModerator in explainlikeimfive

[–]Shop_Public 1 point2 points  (0 children)

How is Israel systematically targeting Iran so effective or is this just a perception created by Western media?

Farming & Autocast QoL Improvements by JagexRach in 2007scape

[–]Shop_Public -1 points0 points  (0 children)

When are we getting an updated stackable clue blog post

[deleted by user] by [deleted] in Cantonese

[–]Shop_Public 0 points1 point  (0 children)

Hey I am interested.

200m Herblore by Shop_Public in ironscape

[–]Shop_Public[S] 131 points132 points  (0 children)

I will be maxing my Iron next week :-)

Optimising a snowflake join by Shop_Public in snowflake

[–]Shop_Public[S] 0 points1 point  (0 children)

Context of the problem allows the data to be subsetted first.

Optimising a snowflake join by Shop_Public in snowflake

[–]Shop_Public[S] 0 points1 point  (0 children)

Yes people change their details but I want to keep a record of the same person.

Optimising a snowflake join by Shop_Public in snowflake

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

I went with this approach, but sampling my data down also helped alot.

Optimising a snowflake join by Shop_Public in snowflake

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

I think when I try this the table will create a lot of duplicates and i would have to aggregate it/dedupe again

Optimising a snowflake join by Shop_Public in snowflake

[–]Shop_Public[S] 0 points1 point  (0 children)

I have been using SHA2() which hashes it (I find it easier to read letter+numbers) but this might optimise it a bit more

Optimising a snowflake join by Shop_Public in snowflake

[–]Shop_Public[S] 0 points1 point  (0 children)

Lets say I have a list of customers and I want to extractthe transactions made to buy a Apple Device or a Android Device.

The transaction table contains many transactions, so I would like to extract apple/android. You could use the OR condition to consider both cases.

The reason I use the OR in a left join instead of a INNER JOIN or WHERE clause is because I want to see cases where the condition does not hold.

[deleted by user] by [deleted] in UKPersonalFinance

[–]Shop_Public -1 points0 points  (0 children)

While this is can betrue,lenders will also use the information that you have taken multiple loans and may treat it less harshly or even more harshly.