What do you think of this post?Awesome (9) Interesting (1) Useful (0) [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 [...]

What do you think of this post?Awesome (0) Interesting (0) Useful (0) 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 [...]

What do you think of this post?Awesome (1) Interesting (1) Useful (1) Hi Frenz, Today morning when I was talking to one of my colleague, he questioned me “Sudheer -  What’s today’s BODI tip?” and at the spur of the moment an idea popped up in my mind (Somehow my mind is driving crazy and working pretty sharply [...]