Total Pageviews

Showing posts with label SQL Override in informatica. Show all posts
Showing posts with label SQL Override in informatica. Show all posts

Monday, 2 June 2014

SQL Override Transformations

By default Informatica server will generate sql query for every action, if that query is not able to perform the exact task, we can modify that query or we can genrate new once with new conditions and with new constraints. Override option is available in following transformations:

1. Source qualifier
2. Lookup
3. Target