" /> Infomart 8.1 - user data mapping - Genesys CTI User Forum

Author Topic: Infomart 8.1 - user data mapping  (Read 2542 times)

Offline Genesysks

  • Newbie
  • *
  • Posts: 3
  • Karma: 0
Infomart 8.1 - user data mapping
« on: March 15, 2013, 06:11:23 PM »
Advertisement
Hi, installing infomart 8.1. it works fine. but now i need to create more then one USER_DATA_CUST_x tables eg. USER_DATA_CUST_1 upto 4
each of them storing cust user data. As per the document(81gim_dep.pdf, page 155) we need to do the mapping as follows:

Modify the script to add to the CTL_UDE_KEYS_TO_DIM_MAPPING table the mapping between the user-data dimension table(s) and the foreign key(s) that you added to the IRF_USER_DATA_KEYS table (Step 8). The script includes the following placeholders:
• USER_DATA_CUST_DIM_1—The user-data dimension table name (which you defined in Step 5)
• ID—The primary key for the user-data dimension table
• CUSTOM_KEY_1—The foreign key for the user-data dimension table

does any one know what would be the The foreign key value in this case ? will it be the PK of each USER_DATA_CUST_x table ? i tried this but it says invalid attribute.

have you every faced any issue while setting up 8.1 infomart. and sample make_gim_UDE_template.sql if any have ?