Aliases
When the IDT sees two join statements between the same two tables, it may propose an alias to resolve the loop. It also may not propose an alias and will only advise you that the cardinalities are confusing. If your company has multiple SQL tools accessing a data warehouse, your DBA may have resolved many of these issues by creating synonyms or views in the RDBMS. For example, one physical CUSTOMER dimension table could be joined to a fact table two times as synonyms SHIP_TO_CUSTOMER and SOLD_TO_CUSTOMER. Synonyms in the source RDBMS appear in the data foundation as physical tables, even though they behave much like aliases. If such synonyms or views do not exist in your RDBMS, create an alias to use one physical table in different ways. ...
Get SAP BusinessObjects BI 4.0 The Complete Reference 3/E now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
