[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 ???