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)
Note: Try It/Edit DataMap requires Apatar Data Mashup installation
Comments:
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?
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)