Results 1 to 2 of 2

Thread: Temporary table creation in Informatica

  1. #1
    Senior Member
    Join Date
    Aug 2012
    Posts
    40,312

    Temporary table creation in Informatica

    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?

  2. #2
    Senior Member vijay's Avatar
    Join Date
    May 2012
    Location
    Hyderabad
    Posts
    514
    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.

Similar Threads

  1. table variable creation in pyodbc / ceodbc
    By Oracleguy in forum Oracle
    Replies: 0
    Last Post: 12-20-2012, 01:30 AM
  2. Table creation script DB2 to MYSQL
    By Oracleguy in forum Oracle
    Replies: 0
    Last Post: 12-16-2012, 12:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •