I would use a mapping table in the load script, something similar to below:
Load [Source IP],
ApplyMap('MAP_IP',[Source IP],Null()) as Source_IP_Name,
ApplyMap('MAP_IP',[Destination IP],Null()) as Destination_IP_Name
Thanks. I was trying to avoid mapping. I wasn't clear in my original statement. The IP address and name table actually has a lot more entries regarding (address, owner, etc.). I want a key that will link both src and dest IP address in table 2 to all of the ip data content in table one. I basically want to have both src and dest IP share a common key to the ip address in table one.