My requirement is to create a temporary table in oracle database, then load the temporary table with a complex sql query. One the loading is done i want to load the data from temporary table to another stage table. All i want to do is this from informatica. How can i do this?
There are two ways you can do this.. Write your sql statements first. 1) Run those statements from pre or post sql in session
2) another way is use the SQL transforamtion in script mode to run those statements.