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!

Register Log in
  • Congratulations Mike Lewis 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

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.
 
Sort by date Sort by votes
what type of sources are u having?
Are they tables or table+flat file ???

 
Upvote 0 Downvote
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

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sa0309
  • Locked
  • Question
Conditional insert into a Target
Replies
1
Views
66
rasETL
rasETL
yimitz
  • Locked
  • Question
InstRev function in SQL for HIR
Replies
0
Views
99
yimitz
yimitz
sa0309
  • Locked
  • Question
Source and Target Issue
Replies
0
Views
66
sa0309
sa0309
sa0309
  • Locked
  • Question
Router Output to a "Single Target Table"
Replies
1
Views
90
rasETL
rasETL
sa0309
  • Locked
  • Question
Informatica Target Table update 1
Replies
2
Views
84
sa0309
sa0309

Part and Inventory Search

Sponsor

Back
Top