RE: How can I write a custom sql on oracle and load the result to postgres?
I have a custom sql which I want to run on my oracle source and then the result of this query I want to load to a postgres table.
Creating the Data Flow becomes more easy now with the 4.5 version. Refer to the screenshots below to see how the same steps look like in 4.5: