Wednesday, September 30, 2009

OTN Discussion Question - Can we use Oracle Migration Tool Kit to Load Stagging?

No... Oracle migration tool kit can be use only to populate the CC&B schema from the staging schema.

So, migrating data from legacy systems to staging schema can be done using any ETL tool.
Depending on the legacy systems, capacity of the source system data being migrated and the budget you can select the the migration tool.
For example, data migration from CIS+ systems to CC&B will be fairly less complicated than migrating from totally different legacy system to CC&B.
Common ETL tools in CC&B migrations I've experienced are IBM websphere Datastage and Informatica powercenter.
These tools works well for large scale migration projects.

Once you migrate data into staging schema, you can use the Oracle Migration Tool kit to perform the following.
1. Validate the information in staging tables (Object validation and Referential Integrity Validation)
2. Any tidy balance
3. Balance Control
4. Key gen
5. Insert data to production schema
6. Balance Control in Production
7. Object and FK validation Productio

Sunday, September 20, 2009

Mad World

I like the melody more than the lyrics of this song...
In a way this is very depressing. After all, the world we live is mad,
and full of chaos.

All around me are familiar faces
Worn out places, worn out faces
Bright and early for their daily races
Going nowhere, going nowhere

And their tears are filling up their glasses
No expression, no expression
Hide my head I want to drown my sorrow
No tomorrow, no tomorrow

And I find it kind of funny
I find it kind of sad
The dreams in which I'm dying
Are the best I've ever had

I find it hard to tell you
'Cos I find it hard to take
When people run in circles
It's a very, very

Mad World , Mad World
Mad World , Mad World

Children waiting for the day they feel good
Happy Birthday, Happy Birthday
Made to feel the way that every child should
Sit and listen, sit and listen

Went to school and I was very nervous
No one knew me, no one knew me
Hello teacher tell me what's my lesson
Look right through me, look right through me

And I find it kind of funny
I find it kind of sad
The dreams in which I'm dying
Are the best I've ever had

I find it hard to tell you
'Cos I find it hard to take
When people run in circles
It's a very, very

Mad World , Mad World
Mad World , Mad World

And I find it kind of funny
I find it kind of sad
The dreams in which I'm dying
Are the best I've ever had

I find it hard to tell you
'Cos I find it hard to take
When people run in circles
It's a very, very

Mad World , Mad World
A raunchy young world
Mad World

Mad World by Tears For Fears

Thursday, September 10, 2009

A Tropical Fruit - Annona

Annona (Aaththa/Anoda-In sri lankan sinhalese terms) often identified as a tropical fruit which can be found in South and North America, including the Amazon ,South East and South Asia.
Annonna is from Annonaceae and has approx 110 specifies, I tasted 4 varieties of them which I found interesting..

1. Prickly Custard Apple (Katu Anoda in Sinhala)
Other Names:Graviola,Brazilian pawpaw, soursop
Scientific Name: Annona muricata


Graviola believed to have cencer healing power. Most of the research on graviola focuses on a novel set of chemicals called Annonaceous acetogenins. Graviola produces these natural compounds in its leaf and stem, bark, and fruit seeds. Three separate research groups have confirmed that these chemicals have significant antitumorous properties and selective toxicity against various types of cancer cells (without harming healthy cells) [1]
[1]:Plant Chemicals http://www.rain-tree.com/graviola.htm

2. Custard Apple(Vali Anoda in Sinhala)
Other Names: Cherimoya
Scientifc Name: Annona cherimola



Seeds are toxic and when crushed can be used as an insecticide.
Native Range: Native to the Andean valleys of Peru, Ecuador, and Colombia. Commercially grown in Australia, South America, Asia, Spain, Italy, and California.

3. Sugar Apple(I'm not sure the sinhala name, I call it Anoda)

Scientific Name: Annona squamosa
My personal favourite!!!





4. Annona cherimola x squamosa (I'm not sure the sinhala name, Lets call it Anoda)
Other Names: Atemoya

Cross between two tropical fruits – the sweetsop (Annona squamosa) and the cherimoya (Annona cherimola) One of the best Annona's, often having a fruitier flavor than the cherimoya.
Fruits tend to be about the size of a sugar apple, often have knobby, green skin, and a custard-like flesh. Fruits may turn slightly yellow when ripe. Atemoya's are high in vitamin C.

Thursday, September 3, 2009

Lightning Stikes

No one would believe if i say I have seen a ball lightning as it is often regarded as a fantasy or a hoax.
I remember when I was around 4-5 years old and back in my home town Anuradhapura, a ball lightning has entered the front door of the house and exited in the kitchen door. It was like a 5-6 cm diameter glowing spherical object which moved 3-4inches above the floor.
I was shocked, and looked at it until it disappears from my view. As I remember Chama (my younger sister) also saw that.
However, cannot guarantee her memory as she was too young.
.
Today, I saw a lightining during the day time from my office window, which reminded me of my childhood experince.
When I was searching about this mysterious object, I found an interesting book, which is available in Google books. Worth reading!
Ball lightning: an unsolved problem in atmospheric physics By Mark Stenhoff