There are many things about data warehousing that are subjective. The use of surrogate keys is clearly not one of them. Let’s start with a quick refresher. Surrogate Key: A system generated value which uniquely identifies a record. Surrogates keys have no business meaning. Natural Key: A value that represents a real world object. Aka […]
ETL often get so complex it is difficult to grasps all of the steps & relationships. LeapFrogBI will now autogenetic interactive component graph feature. You can easily view your project data flow and dimensional model at the click a button. Never get lost in your ETL again!