Results 1 to 2 of 2

Thread: Pre SQL and Post SQL in informatica with example

  1. #1
    Join Date
    Oct 2012

    Pre SQL and Post SQL in informatica with example

    Can any one give me an example when to use the pre sql and post sqls in informatica?

  2. #2
    Join Date
    Oct 2012
    Blog Entries
    Pre sql and post sqls are used to do some cleanup operations, auditing, index drop and creations on the database side.

    Example: When you want to load a huge amount of data in the target table and the target table has indexes defined on it. Then the loading will take a lot of time. To improve the performance of laoding, in the pre sql first drop the indexes on the table, then load the data into the table and in the post sql create the indexes on the table.

Similar Threads

  1. Example for Pre and post increment operators in JAVA
    By Sanvi in forum Java programming questions and examples
    Replies: 0
    Last Post: 03-07-2013, 06:19 AM
  2. SQL Server repository for informatica powercenter
    By amrutha in forum Data Warehouse
    Replies: 0
    Last Post: 12-28-2012, 05:10 AM
  3. Replies: 0
    Last Post: 12-17-2012, 12:38 AM
  4. Pre/Post Increment operators in C
    By sarvani in forum Programming languages
    Replies: 1
    Last Post: 07-05-2012, 11:22 AM


Posting Permissions

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