Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

several source in one target

Status
Not open for further replies.

monrow

Technical User
Apr 22, 2008
29
FR
Hi all,

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.

thanks.
 
what type of sources are u having?
Are they tables or table+flat file ???

 
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

Ties Blom

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top