It depends on the table size we can't say that joiner will give better performance.
In informatica,whenever we use joiner transformation it will implicitly sort data before performing the join operation where as in the lookup transformation it will be full table scan.
For the better performance , we should make use of not exists clause in the source qualifier instead of looking up the target.
Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!