How to remove Lookup OrderBty clause added automatically By Informatica



End your Lookup Override SQL with --

SELECT
col1 as col1
col2 as col2
WHERE col1 ="something"
and col2 in (9017,9014) --
By -

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Limitations of Pushdown Optimization - PDO

Limitations of Pushdown optimization. Source and Target and Lookups must be in same database server for full Pushdown. Expressions w...