Notifications
Clear all

Error in the Temporal PIT SQL example in section 14.4 of the book?


Posts: 38
Topic starter
(@saqibali)
Eminent Member
Joined: 1 year ago

Hello,

Re: Section 14.4  in Building a Scalable Warehouse using Data Vault 2.0 book (page 615).

The SQL example for loading the Temporal PIT uses LEFT OUTER JOINs. Shouldn't these be INNER JOINs? LEFT OUTER JOIN will all the records from the HUB.

 

Please advise. 

 

Thanks.

Reply
3 Replies