Tip of the day – Pushdown_sql()

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

[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 

Tip of the day – Importance of Annotations

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

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!

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

Tip of the day – Compact Repostiory

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

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 these days 🙂 ).  Why can’t I share DI tips which I’m aware of and which would be useful.

Note: You can find all my technical tips by selecting the “Tip of the day” in the category list starting from today.

Today’s tip topic – Compact Repository

Compacting/Compressing the local repository on regular basis would definitely help your repo to respond quickly. What happens is… whenever you save any object in DI designer, the new version of the object information will be written into your local repo. Repository compression process removes the unnecessary and obsolete information from your local repo and thus helps to respond your repo quickly.

 

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