Start a new topic
Answered

How to retrieve the list of tables used as the source in a mapping

Hello, 


I want to retrieve the list of tables used as the source in a mapping. 

However, the following syntax allows me to retrieve the physical name of the main table %x{md:physicalName($REF/ref:source())}x%, but not the tables in joins. 


Could you please provide me with the syntax to achieve this? I have been unable to find it.





Best Answer

Hello,


The solution is: 


To retrieve the list of source tables, you can use the expression below:


%x{

md:list($REF/

ref:froms()/ref:target()/tech:physicalPath(),'\n')

}x%





1 Comment

Answer

Hello,


The solution is: 


To retrieve the list of source tables, you can use the expression below:


%x{

md:list($REF/

ref:froms()/ref:target()/tech:physicalPath(),'\n')

}x%





Login to post a comment