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
Can you please also let us know the Cardinality between recipient and BR_Code schema ?
It might be to do with the cardinality, if you have 1-1 or N-1 cardinality from Recipient to BR-Code you can use it directly it in delivery. Otherwise you to enrich it using enrichment activity first and than use it as targetdata in delivery.
I am not sure I understand the data model here. Can you confirm that all your data (including custom fields) are part of the recipients table? Or do you use a different table - related to the recipients table - to store the brData?