O'Reilly logo

SQL Server 2017 Integration Services Cookbook by Dejan Sarka, Matija Lah, Christian Cote

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using the cascading lookup pattern

Typically, the structure and the semantics of a data flow source correspond to the data model used in the source data store; this structure, or the semantics used to represent data in the source system, might not be aligned with the structure or the semantics of the destination system.

For instance, the client entity in the source system might be represented by a single set, but the data warehouse might have to distinguish between a client, who is a person, and a client that represents a company. To correctly interpret the source data, you would need appropriate logic in the data flow to differentiate between source rows representing persons, and source rows representing companies, before loading the data ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required