You can use a lookup anywhere within a mapping, whereas you need a SQ to fetch data from a database at the start of a mapping. A joiner is strictly an object that works within the ETL engine (for joining data that is already fetched)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.