Subscription

RSS Feeds List RSS Feeds List

Top Developers


Patryk Szczypien
Created the CurrentTimestamp function

Proud Sponsor of

Main Repository Page arrow Business Management

Splitting records into two destination tables       >>

Try It / Edit It

DataMap Description: Transfrom records from the only one source to 2 targets, where primary key generation from the first destination table is the foreign key on the second destination table. (as per user request http://www.apatarforge.org/forums/viewtopic.php?t=504&start=0)

Updated: about 3 years ago

Created By: Sergei (Sergei)

File Size: 41.85 Kb

Views: 9233

Downloads: 110

Tags: Custom Table

Rating: stars/0.gifTotal Votes:0

Note: Try It/Edit DataMap requires Apatar Data Mashup installation

Comments:

anonymous.gif
taaffe 2009-08-04 03:46:34
can you please explain this. I find it toally baffling. You sample that I downloaded seems to take to sources and put them in one destination, not the other way around. How about some explanation of what it is doing?
anonymous.gif
Sergei 2009-08-04 04:02:36
I've just updated the datamap with Tables' names. I took one and the same source (Source table 1) and migrate needed records to Destination table 1 and Destination table 2. When you join records the Join on condition should be "inner" and fields you join your records must be unique in order not to create duplicates. Please download this datamap again. If you have other issues feel free to contact me directly (sergei.l @ apatar.com)

Add Comment:

Name (required)
Comment (required)
Verification code:
 
 
  Terms and Conditions Privacy Policy Contact Info Comments and Suggestions ETL News