Rick sherman’s Beyond ETL and Data Warehousing article on Information Management and his blog post on Data Fedaration
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 ???