I've a mapping use one target,and serveral sources.
How can i do, to centralise all the sources in one transformation .
sources come from mapplet or ohter sources with transformation.
Best practice is to use a source qualifier for each of the sources, unless you have directly related PK-FK tables combo's which would allow you to let the source database perform joins.
With multiple source qualifiers you can then perform joins/unions by using the INFA engine
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.