Thanks for the inputs.
I have tried hard coding the second UDA into the flat file as below and none of them worked. (My delimiter is |)
"UDA1|UDA2" & "UDA1| UDA2".
Tried Mappings as (* to *) & (* to "*")
The UDA is getting loaded a literal string in all scenarios. I am not sure what else I am missing.
The output from Data Management for multiple UDAs will need to be enclosed in quotes, the UDAs will need to be split by either a comma or a tab depending on the load rule target option - "Member name may contain comma"
If "Member name may contain comma" is set to yes, Data Management will create a tab delimited file that is loaded to PBCS, if it is set to no it will be comma delimited.
Here is an example with it set to no.
source file, split by PIPE and the UDAs are split by comma, if you want separate columns for the UDAs then you could join them using a mapping and a lookup dimension
Rule target option set to no so the output file generated from DM will be comma delimited.
Mapping to add quotes for the UDA
File generated by DM before loading to applicationMultiple UDAs created in application
Thanks a lot John.
In my file I had the pipe delimiter between the UDA's. I had changed it command as you suggested and it is working.