SQL Server Reporting Services Question:
Download Questions PDF

Lookups are a key component in SQL Server Integration Services (SSIS). Explain its purpose?


Data from two sources is combined by Lookup Transformation. There are matching fields from these sources. Case insensitive transformations is performed by the lookups. For the purpose of accessing additional information in relation to the tables is one of the purposes of lookups. Lookups can be used in data warehousing.

Lookups are used for the following purposes

► Data Cleansing
► Error Tolerance
► Data search in data warehouse
► Optimizations using cache modes

Download SSRS Interview Questions And Answers PDF

Previous QuestionNext Question
How to Generate an Auto Incremental Number in a SSIS Package?How to unzip a File in SSIS?