Flashcards
LOOKUP Transformation
Cards in this deck (15)
- 1Lookup Transformation 1Lookup data in flat file, relational table, view, synonym, SQ
- 2Lookup Transformation 2 - typeActive or Passive
Connected or Unconnected - 3Lookup Transformation 3lookup ports and lookup condition
results returned to target or another transformation
single row or multiple rows - 4Lookup Transformation 4 - tasksget a related value
get multiple values
perform a calculation
update slowly changing dimension - 5Relational Lookupoverride default SQL statement - add WHERE clause or query multiple tables
sort null data high or low
perform case sensitive comparisons - 6Connected Lookupis connected to source or target in a mapping
uncached or static lookup - returns values from the query
dynamic cache - cache is updated or not
result can be passed to a Filter or Router - 7Unconnected Lookup:LKP lookup_trans_name(arg1, arg2...argx)
:LKP expression can be in Aggregator, Expression, or UPdate Strategy
if no value is found, query returns null to the port
use static cache - 8Lookup PortsInput - at least one
Output - can be input or lookup
Lookup -
Return - only unconnected - 9Lookup CacheSequential and Concurrent cache
Persistent cache - to reuse next time
Recache from source - if persistent cache not synchronized
Static cache - IS default
Dynamic cache - updates the cache
Shared cache - between multiple transformations - 10Dynamic CacheTo keep synchronized with target
Relational, flat file, and pipeline lookup
Insert row, Update row, No change in cache - 11Dynamic Lookup PropertiesNewLookupRow =0, 1 = Inserts, 2=Update
Associated Expression
Ignore Null Inputs for Update
Ignore on Comparison
Update Dynamic Cache Condition - 12Dynamic Lookup - Null ValuesInsert Null Values - IS updates the lookup cache and target table using all values from the source
Ignore Null Values - updates the lookup cache and target table using only - 13Dynamic Cache - Insert Else Updaterow type is Insertexisting rows in the dynamic lookup when the
- 14Dynamic Cache - Insert Else UpdateIf row type is Insert and Insert else Update is selected then
If the row is new - inserts the new row in the cache
If the row exists - update existing rows in the dynamic lookup cache
If row type is Insert and Insert else Update is not selected then
If the row is new - it inserts new row
If the row exists - it does not update the existing row - 15Dynamic Cache - Update Else InsertInsert new rows in the dynamic lookup cache when the row type is Update
Information
- Description
- Flashcards on LOOKUP Transformation, created by v_krejci on 16/11/2015.
- Created by
- v_krejci
- Views
- 0
- Rating