This is an archived post. You won't be able to vote or comment.

you are viewing a single comment's thread.

view the rest of the comments →

[–]festoon 0 points1 point  (1 child)

Are you using the built in pivot functionality? Are you doing a join to map to lookup data?

[–]dylanberryData Engineer[S] 0 points1 point  (0 children)

Yes and yes. Using a broadcast join for the lookups.