data droping on SAS CMS

[Fdwa-Adwan]

Why when I import data to SAs CMS it drops around 3% from it although the " hold out" is disable? 

[JamesAnderson]

HI,

Can you please clarify what you mean by import data ?

and how have you determined that records are being dropped ? is it showing "XXXX dropped" on the communication node ?

Regards

James

[Fdwa-Adwan]

using "import external node" node to import data (MSISDNs) form outside SAS, is always dropping X amount of MSISDNs, this not only when importing, when we do any campaign on SAS we fund that some customers who match the criteria were dropped, this when we don't enable the hold out. 

[JamesAnderson]

HI,
Sounds like this "import external" node is a custom node developed for your organisation, so you will need to check with your internal support team as to how it works. But in general the way that MA runs its queries against the database is that there is a "primary" table for each subject level, and this table must contain the entire universe of subject_ids (for you it seems that means MSISDNs). Each query from a campaign always joins to this primary table. So if you load a another table with an MSISDN that isn't in the primary table, it will get dropped.
Regards
James