It is hard to automate this - as you would need to know what the correct result from the mapping.
What i usually look for is :-
- did connection assignment happen for all connections
- were there any missing links
We have the same issue. Hundreds of mappings with extremely parameterized calculations at columns. Missing links only useful for identifying the missing connections to the objects but not to the column level calculations.
I'm surprised that this is not answered with a approach for verifying if all my PC content is pulled correctly in EDC. How do we confirm to the business that the lineage is good at every hop.
the lineage within the PC metadata (detailed lineage) should be ok - the scanner should be importing all of the transformations and ports & the lineage/operations used.
you can use the relationships api endpoint to query both summary and/or detailed lineage relationships
even at the summary level - the PC scanner will store some operation information (com.infa.ldm.etl.pc.Operation) that can be used to identify what expression logic is used.