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 ???
Whenever you use any of these options like Auto-Correct Load, API Bulk Load, Triggers, pre-load/post-load commands on target table, its always recommended to describe the steps in an annotation note. It helps in many situations, for example, you renamed the target table name in underlying database and you might want to change it in your dataflow as well. Once, you replace the existing table with the renamed table, you might forgot to set some of your target table options. It really helps a lot particularily in such kind of instances, you can pretty much refer your annotation note and set all your target table options with ease.
Hope this tip helps!