Tags » ODI

Best batting averages in ODI cricket in 2016

VIrat Kohli enjoys a Bradmanesque batting average in ODIs this year. His batting average in 2016 in ODIs is 92.37. The next best batting average among players who have scored at least 700 runs this year is 61.91 by Alex Hales of England. 43 more words

Pivoting Data in ODI 12c

HI Friends,

Here is another exmaple of using PIVOT in ODI 12c, till ODI 11g we didn’t have these components available in ODI hence we have to perform this using decode functionality but from 12c onwards it became easy :P. 624 more words


Using the Unpivot Component in ODI 12c

HI Friends,

Once again I am back with an example of Unpivot in ODI 12c.

You can use the following SQL statements to recreate this example in your environment. 406 more words

8. Set Dimensional Properties for a Datastore and Its Columns

This will cover…

  1. Set Dimensional properties for a datastore
  2. Set Dimensional properties for columns of a datastore

1. Set Dimensional properties for a datastore

  • Go to Designer –> Models –> Select Appropriate Model Folder –> Expand Appropriate Model –> Right click Table which you want add Dimensional Property and select Open…
  • 66 more words

7. Viewing Data in ODI

There are two modes to viewed data from datasources

  1. Read-only mode (includes File and XML Technology)
  2. Read-right mode

This will demonstrate how to view data from datasources… 36 more words


Sanitation under stress: how can urban services respond to acute migration?

This working paper aims to identify key research questions around the successes and failures of urban governance structures in delivering essential services to populations following large migration movements. 12 more words


Country evaluation brief: South Sudan

While the international community is primarily concerned with trying to restore stability and providing protection and relief to an increasing number of people in South Sudan, evaluations of past development interventions provide important lessons that are relevant for future aid policy and implementation. 19 more words