BR_Code remains constant but other details keeps changing (in a day or two).
Recipient Schema has customer email id & @text1 field of recipient table has BR_Code so that it can be mapped with brData .
When I query Targeting dimension as Recipient & Filtering Dimension as brData and condition as BR_Code = 'A',it returns all customers in Recipient table with BR_Code as A but when I try to personalize BR_Manager_Name or BR_Manager_EMAIL_ID or BR_Manager_Phone#
it returns undefined.
The syntax I have used in delivery to personalize is <%= recipient.brdata_Recipient.BR_Manager_Name %>.
When I use <%= recipient.text1 %> for Branch Code, it works perfectly fine but <%= recipient.brdata_Recipient.BR_Manager_Name %> is not working.
But, I think it might create a issue for you. You have defined brCode as primary key for you Br_data schema, by due this you are defining that each and every recipient will have different brCode, recipient can't share br Code. Adove code will define 1-1 cardinality between Recipient & BR_Data.
If multiple recipient can share same br code, than you need to define link with below code using unbound= "true", this might solve your problem