Client journey and Mapping table can be brought into CM Data as it already contains it. Zip code can be linked to store location, just can’t seem to link store location to my fact table which is CM Data.
In my mind i will make 5 tables to 3 tables, please advise?
Thank you in advance.
Hi @Yrstruly - Seems like Web Scraping data. If data is already there in CM, then yes no need for extra table. Yes, can keep only 3 tables instead of 5.
Regarding linking store location to my fact table which is CM Data, if CM doesn’t have this information then don’t think it will be possible to link them.
Thanks
Ankit J
Hello @Yrstruly, it’s been a while since we got a response from you.
Just following up if you still need help with your inquiry?
If you do, kindly provide the information the experts requested above so they can help you further.
In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.
Hi @Yrstruly, due to inactivity, a response on this post has been tagged as “Solution”. If you have any concern related to this topic, you can create a new thread.
