Informatica Truncate Target Table

In the Target Table session properties there is an option to Truncate existing data before loading. It is important to realize Informatica does not always use the TRUNCATE function to clear the table, sometimes a DELETE statement is issued, this decision is made at runtime depending on different factors, noted in the table below.

 

Depending on your needs, TRUNCATE may be what you want because it deletes by deallocating the data pages, freeing storage, and resets Identity column. If the integration service uses DELETE, you may get unexpected results.

You can however issue the TRUNCATE yourself in the target Pre SQL.

 

Conclusion

Research your database’s TRUNCATE and DELETE properties and review how Informatica handles the Truncate option.

More Information


Thank you for your support
 or  PayPal


 

IMPORTANT,  YOU are responsible for backing up your systems before trying or implementing any suggestions from this blog. I do not guarantee 100% accuracy of any code examples. I do not presume to know your system environment(s) or Security requirements; all code examples from this blog should be thoroughly tested before any attempted use on a production system.

0 Response to "Informatica Truncate Target Table"

Post a Comment