The difference between cache and uncacheed lookup iswhen you configure the lookup transformation cache lookup it stores all the lookuptable data in the cache when the first input record enter into the lookup transformation, in cache lookup the select statement executes only once and compares the values of the input record with the values in the cachebut in uncache lookup the the select statement executes for each input record entering into the lookup transformation and it has to connect to
database each time entering the new record
No comments:
Post a Comment