I have 30 tables to lookup on 30 respective columns,
In case of other ETL tool we had lookup as a function to do it independently in a single transform.
In snaplogic, I am not sure how to do it. I can combine all 30 into a single lookup table like
Soure_column, Target_Column, Lookup field
But again, if I use this in sql server lookup, and return Target_column as output field for each 30 cross refrence its working as and operator and giving me null.
Can someone help me with how I can crack this in a simple way, since I do not want to do 30 joins.