I have created a custom object which is linked to a lead object using a column called brand id. Each contact is associated with one brand id. Now when I load records to this custom object, I expect each record get linked to multiple leads as there are more than one lead under each brand id. However, when I load the data this custom object, each record is linked only to the one contact under that brand. Please help fix this. Happy to share more details.
You need to use a junction object to create 2nd-level objects. Warning, though: 2nd-level is not available from Velocity. So you need to be very careful with your expectations.