is empty lookup table the same as non-matching lookup table in lookup transform?
what would be the result if no row redirection is configured? 1) an empty result set or 2) package failure at the lookup transform
is empty lookup table the same as non-matching lookup table in lookup transform?
what would be the result if no row redirection is configured? 1) an empty result set or 2) package failure at the lookup transform
You could get #2: Package failure. It would not be able to find the row in the lookup table (since it's empty).
Edit: I should say that if you set the Error Configuration to Ignore Failure
, you will get an empty rowset.