Tip of the day – Pushdown_sql()

What do you think of this post?
  • Awesome 
  • Interesting 
  • Useful 

-- Download Tip of the day - Pushdown_sql() as PDF --


[amazon-productcloud]3a1bcc99-70a5-48a8-a6ad-f3a9066d8dd3[/amazon-productcloud]Hi All,

While debugging dataflows in DI,  some times we want to limit the soruce dataset with rownum <100. The best way to use rownum in Data Integrator is, add pushdown_sql() in query transform under the where condition tab and write a statement like this

pushdown_sql(‘My_DataStore_Name’, ‘rownum < 100’)

Now check the optimized sql, it generates similar sql and the good part in this is, the code will be pushed down to the database

SELECT column1, column2, column3 FROM table WHERE rownum<100

Awesome!!!… isn’t it ???

What do you think of this post?
  • Awesome 
  • Interesting 
  • Useful 

One comment on “Tip of the day – Pushdown_sql()

Leave a Reply

Your email address will not be published. Required fields are marked *


*