What is Intelligent Lookup in SAP DWC-MD - Data Warehouse Cloud - Modeling (Data Builder)?

SAP Term: Intelligent Lookup

• Component: DWC-MD

• Component Name: Data Warehouse Cloud - Modeling (Data Builder)

• Description: An object created in the Data Builder, which takes an input entity to be enriched with additional columns and a lookup entity to provide theenriching columns, and combines them via one or more exact or fuzzy match rules. An intelligent lookup helps modelers to combine data from two entities, even if there is no appropriate foreign key column to create a standard SQL join or if the foreign key data is incomplete or unreliable, as it can match data across multiple columns, and users can review and manually process the output of each rule. Used where a standard join in a view would not be possible or would give incomplete data.

Smart SAP Assistant

• Key Concepts:
  Intelligent Lookup is a feature of SAP DWC-MD Data Warehouse Cloud - Modeling (Data Builder) that allows users to quickly and accurately search for data within their data warehouse. It uses natural language processing (NLP) to understand the user’s query and then searches the data warehouse for the most relevant results. It also provides suggestions for related terms and synonyms, making it easier to find the right data.
  
  How to use it:
  To use Intelligent Lookup, users must first create a data warehouse in SAP DWC-MD Data Warehouse Cloud - Modeling (Data Builder). Once the data warehouse is created, users can access Intelligent Lookup by clicking on the “Search” icon in the top right corner of the screen. From there, users can enter their query and Intelligent Lookup will search the data warehouse for relevant results.
  
  Tips & Tricks:
  When using Intelligent Lookup, it is important to be as specific as possible when entering your query. This will help ensure that you get the most accurate results. Additionally, it is helpful to use synonyms and related terms when searching, as this can help you find more relevant results.
  
  Related Information:
  For more information on Intelligent Lookup, please refer to the SAP DWC-MD Data Warehouse Cloud - Modeling (Data Builder) documentation. Additionally, there are many online tutorials and videos available that provide step-by-step instructions on how to use this feature.