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!

Two Disjoint Sources

Status
Not open for further replies.

asth01

Programmer
Jan 18, 2004
36
US
Hi,

We have to populate data from 2 tables into one table.
The 2 source tables don't have any relations.

What will be the best approach to create mapping for this ?

Thanks in advance,
 
Any luck with this?

If there's absolutely no relationship, either create a single map with both sources independently going to the target or two separate maps. Note in case 1, you'll need 2 targets in the map.
 
Alternative is to use a union statement (SQL override) to merge the two data-sources. This will work for number of fields the same and the same datatypes:

Select A,B,C from X
UNION
Select M,N,O from Y

T. Blom
Information analyst
tbl@shimano-eu.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top