Validate data in file while loading into SAC Master Data Dimension

[sivapuram_phanikumar]

Hello Friends - I am new to SAC and am working on doing a master data load from an excel file to a dimension. For this I am following below steps:

1. Created an import job using file as source.
2. Created a multi action referring to the import job and
3. Created a story to trigger the multi action.

This works fine. However, I would like to (apologies for asking these questions. but curious to know)

• Validate some attributes to ensure they do exist in the system. If they don't exist, I would like to raise an error message asking to enter a valid (let's say cost center)
• Populate values in text attributes (ex: cost center description)
• When I click on "Multi action" button in the story, it says something like, "Multi action is running...". Can I give a different message on the pop-up?

Thanks,

Phani