Hi I am back with another newbie question.
I am trying to write a data source with complex joins (more than 3 tables). And though I can do it with merge/join transformation, it is more simpler to write the query in place of the source.
the Lookup transformation allows me to write a SQL query but it requires an input data source. What I want is that the custom query itself is the data source. Is there any transformation/option available for me to do it?
any help would be highly appreciated.
[Please mark the post as answer if it answers your question]
View Complete Post