I would like to export the Source to Target mappings from the tMap into a human readable format (like Excel) so that my client may review and feedback.
excuse I did not understood well your question. if you want to export your tMap Mapping there is 4 way: 1: go to code tab … it's not easy to read. 2: go to project path to extract XMl code of tMAP… it's not easy to read. 3: use Print Screen create your documentation manually 4: use help generator: Right click on job "GenerateDoc as HTML" good luck
To be honest, the business user should provide the mapping specification to the developer. The developer should work to that. However you can build a job to interrogate the job's .item file to pull the mapping info out of that. The .item file is an XML file, so it wouldn't be too hard. However you are likely to pull out a bit of Java. I'm afraid it is unlikely you will get this into an Excel file without a bit of Java to read, without a fair amount of work.
the solution is on unity test. it's on dev side. so make a decision tree to check all cases. valid them with unity test. Give this doc to your business user and ask him/her to give you some reals samples/use cases ,to help him/her on validation. good luck
