Sunday, September 12, 2010
Data Migration Architecture
This article outline the detail end to end data migration technical design. Below diagram illustrate at a high level all the different components involved.
Thursday, March 25, 2010
Oracle SQL: Finding Overlapping Dates
When the object validation error reported,
"An account cannot have multiple auto-pay options effective at the same time"
To find out the overlapping dates, following query became handy. This can be generalized for any situation where overlapping periods of data needs to be identified.
SELECT *
FROM (SELECT acct_id,
start_dt,
end_dt,
CASE
WHEN NOT (start_dt > Lead(end_dt)
OVER(PARTITION BY acct_id ORDER BY start_dt, end_dt)
OR end_dt < Lead(start_dt)
OVER(PARTITION BY acct_id ORDER BY start_dt, end_dt))
THEN 'Yes'
ELSE 'No'
END AS overlap
FROM ci_acct_apay)
WHERE overlap = 'Yes'
"An account cannot have multiple auto-pay options effective at the same time"
To find out the overlapping dates, following query became handy. This can be generalized for any situation where overlapping periods of data needs to be identified.
SELECT *
FROM (SELECT acct_id,
start_dt,
end_dt,
CASE
WHEN NOT (start_dt > Lead(end_dt)
OVER(PARTITION BY acct_id ORDER BY start_dt, end_dt)
OR end_dt < Lead(start_dt)
OVER(PARTITION BY acct_id ORDER BY start_dt, end_dt))
THEN 'Yes'
ELSE 'No'
END AS overlap
FROM ci_acct_apay)
WHERE overlap = 'Yes'
Sunday, January 24, 2010
Wednesday, December 16, 2009
Got to read this article, then again I don't have time...
Workaholism is a disease. Here’s how to cure yourself...
I skimmed through this article in the early morning today in yahoo news. yeah, for me early morning is 8 am. Haven't had much time to read it thoroughly. It seems an interesting one, this for my reference and any others who spend great share of life at work.
Only thing I can complain about this article is it's not gender neutralized. In all references 'He,husband,men or fathers' been used. I know I shouldn't be fussed about it too much, after all this is from "Australian Mens Health" magazine.
Realisation and Workout
Step 1
Admit that you’re powerless in the grip of your addiction to work.
This is not easy. Companies throw too many rewards at you in recompense for your addiction. You also have to fight the common perception that to work until you drop is an admirable quality, particularly in middle-managers who have a shot at becoming upper-tier supervisors if they labour until their hearts explode.
What it takes is a realisation that you’re not really happy . . . that sleep is difficult . . . that you’re having sex too infrequently, or too often, or with the wrong people. Or you’re playing too much golf, which often goes hand in hand with addiction to work. Both take way too much time, detach you from reality and come with cool gear.
Step 2
Acknowledge there are things in life more important than work.
A few years ago, I realised I’d missed most of my son’s birthday parties because our annual sales meeting takes place the last weekend of his birth month. That’s not good. If you find yourself missing things . . . wondering why the hell you’re doing what you’re doing . . . sitting in front of a laptop while everyone else is at the beach . . . you may be ready to accept that you’re leaving much of your life behind. And that no matter how much money you make, you won’t be issued a second life.
This doesn’t mean, by the way, that you should drop all the balls you’re juggling. You should keep working, driving for whatever goal you have your eye on, while at the same time avoiding a tip over into a workaholic relapse. How? By becoming a manager, stupid. The purpose of management is to make other people do the things that need doing, so you can think about strategy and leave early. If you’re serious about overcoming your addiction, use other people to get the job done.
Step 3
Accept that you cannot control every little thing in the universe.
Workaholics are pursuing a perfect solution to the problem of existence. That’s why they try to control everything within their scope. Identify a challenge. Put your shoulder into it. Make it go away. Just as it disappears, whoops, here comes another one. It’s like a game of whack-a-mole that never ends.
Step 4
Recognise that work is a temporary fix for spiritual issues you have yet to fully comprehend.
I once went to a Quaker meeting. You sit for an hour without speaking. Nobody else speaks either, unless he or she has something important and brief to offer. Then everybody lapses into silence again. It was the longest hour of my life. I couldn’t stand it. I thought I would go completely around the bend. That experience really aught me something. That deep inside, I am broken, and that I’m using work to plaster over some yawning gap within myself.
Step 5
Appeal to the higher power of your choice for assistance with your transformation.
Some people pray. Others jog. Still others purchase $3000 bikes, coat themselves with Spandex and pump six hours up the nearest mountain. It doesn’t matter. The goal is to draw on reservoirs of strength that defy rational thought, so you can wrench your poor, obsessed spirit away from work and orient it toward stuff that matters.
This is hard for career workaholics. We tell ourselves we’re “doing it all for them”, whomever “they” may be, but really, men like us are lonely, isolated, self-involved, and bundled into an armour of our own devising.
We have to move outside of ourselves if we’re going to break the cycle of addiction. A few higher powers to consider: family, kids, love, enlightenment, peace of mind, helping others. Careful with that last one, though: I’ve seen more than one workaholic transition from obsessive businessman to maniacal philanthropist.
Step 6
Make amends to the people harmed by your affliction.
If you have kids, start there. If you have a list of former lovers who couldn’t put up with your hours anymore, consider them for a while. How about dear old Mum, who you haven’t seen since her silver hair was merely streaked with grey? How about Dave, your best friend from college, who has been trying to get in touch with you for . . . could it possibly be 15 years?
Step 7
… but don’t injure them in the process.
This is not an exercise in self-actualisation at other people’s expense. That’s what you’ve been doing up until now. This is about acknowledging your faults to the people you’ve hurt without hurting them more. When in doubt, keep your trap shut and just sit at home feeling bad about yourself for a while.
Step 8
Replace work with other things that give you satisfaction.
This may be the most difficult step of all. I’m so far away at this point that I can’t even tell you how to approach it. Perhaps, for people like you and me, there’s a sunrise out there that will be as wonderful to behold as the closing documents on a killer acquisition. I hope so. Truly I do.
Step 9
Carry this message to fellow workaholics and make yourself available in their times of need.
That’s pretty much what I’m doing here today – asking you, right now, to sit down, take a deep breath and stop. Try to see a future beyond the random motion of your daily affairs. And in the silence that surrounds you, ask yourself: is there something I should not be doing? Imagine yourself there. Take that first step. But check your email first, okay? You’re paid too much to sit around reading magazines all day, you know.
How your work ethic is ruining your life
It’s easy to understand how men becoming workaholics. “The expectation to excel and be the breadwinner leads to excessive focus on achievement,” says Dr Diane Fassel, author of Working Ourselves to Death. But what about the hidden costs? Here’s what to expect if you maintain this schedule:
Obesity. According to a 2006 survey published in the Harvard Business Review, half of all workaholics don’t exercise enough, and two-thirds don’t sleep enough. Neither scenario is good for your BMI. A study by Case Western Reserve University in the US revealed that people who sleep less also eat less – but gain more weight.
High blood pressure. People who exceed 50 hours of work a week are 29 per cent more likely to have high blood pressure, and are at higher risk of heart disease and stroke, according to a 2006 study from the University of California at Irvine.
Heart attack. Men who work 60 hours or more a week are twice as likely to have a heart attack as those who work 40-hour weeks, according to a 2002 Japanese study by Kyushu University.
Divorce. Women married to workaholics are less emotionally attached to – and feel less desire for – their husbands, according to research at the University of North Carolina.
Messed-up kids. A separate University of North Carolina study found that children of workaholic fathers have significantly higher levels of depression and anxiety.
– Anna Maltby
I skimmed through this article in the early morning today in yahoo news. yeah, for me early morning is 8 am. Haven't had much time to read it thoroughly. It seems an interesting one, this for my reference and any others who spend great share of life at work.
Only thing I can complain about this article is it's not gender neutralized. In all references 'He,husband,men or fathers' been used. I know I shouldn't be fussed about it too much, after all this is from "Australian Mens Health" magazine.
My name is Gil Schwartz and I am a workaholic. It’s an addiction like any other. Except that if you have it, you’ll earn more. Actually, a lot more. I’m recovering, though. I have to. The Japanese have a word for the problem: karoshi. It means “death from overwork”.
And I’m not talking only about men who keel over face-first in their sushi. I’m talking about death of the soul: a dependency on stress, aggravation, power and control; an inability to think about anything but deals, meetings and upcoming challenges; a draining away of the joy we should feel about food, drink, love, sex, children and little birdies.
It’s a tough addiction to conquer because you have to do it while continuing to work. That’s like being asked to quit drinking while being required to have a glass of wine every evening.
And yet it can be done; this program can help. It’s only nine steps because, frankly, who has time for 12? It’s working for me. A few days ago, I took a walk with my wife and did not take my BlackBerry! That’s progress. Of course, I reached into my empty pockets six or seven times, so clearly I have a long way to go. But I’ll cure myself, one symptom at a time. Feel free to join me. You have nothing to lose but your identity as a faceless, soulless company man.
Realisation and Workout
Step 1
Admit that you’re powerless in the grip of your addiction to work.
This is not easy. Companies throw too many rewards at you in recompense for your addiction. You also have to fight the common perception that to work until you drop is an admirable quality, particularly in middle-managers who have a shot at becoming upper-tier supervisors if they labour until their hearts explode.
What it takes is a realisation that you’re not really happy . . . that sleep is difficult . . . that you’re having sex too infrequently, or too often, or with the wrong people. Or you’re playing too much golf, which often goes hand in hand with addiction to work. Both take way too much time, detach you from reality and come with cool gear.
Step 2
Acknowledge there are things in life more important than work.
A few years ago, I realised I’d missed most of my son’s birthday parties because our annual sales meeting takes place the last weekend of his birth month. That’s not good. If you find yourself missing things . . . wondering why the hell you’re doing what you’re doing . . . sitting in front of a laptop while everyone else is at the beach . . . you may be ready to accept that you’re leaving much of your life behind. And that no matter how much money you make, you won’t be issued a second life.
This doesn’t mean, by the way, that you should drop all the balls you’re juggling. You should keep working, driving for whatever goal you have your eye on, while at the same time avoiding a tip over into a workaholic relapse. How? By becoming a manager, stupid. The purpose of management is to make other people do the things that need doing, so you can think about strategy and leave early. If you’re serious about overcoming your addiction, use other people to get the job done.
Step 3
Accept that you cannot control every little thing in the universe.
Workaholics are pursuing a perfect solution to the problem of existence. That’s why they try to control everything within their scope. Identify a challenge. Put your shoulder into it. Make it go away. Just as it disappears, whoops, here comes another one. It’s like a game of whack-a-mole that never ends.
Step 4
Recognise that work is a temporary fix for spiritual issues you have yet to fully comprehend.
I once went to a Quaker meeting. You sit for an hour without speaking. Nobody else speaks either, unless he or she has something important and brief to offer. Then everybody lapses into silence again. It was the longest hour of my life. I couldn’t stand it. I thought I would go completely around the bend. That experience really aught me something. That deep inside, I am broken, and that I’m using work to plaster over some yawning gap within myself.
Step 5
Appeal to the higher power of your choice for assistance with your transformation.
Some people pray. Others jog. Still others purchase $3000 bikes, coat themselves with Spandex and pump six hours up the nearest mountain. It doesn’t matter. The goal is to draw on reservoirs of strength that defy rational thought, so you can wrench your poor, obsessed spirit away from work and orient it toward stuff that matters.
This is hard for career workaholics. We tell ourselves we’re “doing it all for them”, whomever “they” may be, but really, men like us are lonely, isolated, self-involved, and bundled into an armour of our own devising.
We have to move outside of ourselves if we’re going to break the cycle of addiction. A few higher powers to consider: family, kids, love, enlightenment, peace of mind, helping others. Careful with that last one, though: I’ve seen more than one workaholic transition from obsessive businessman to maniacal philanthropist.
Step 6
Make amends to the people harmed by your affliction.
If you have kids, start there. If you have a list of former lovers who couldn’t put up with your hours anymore, consider them for a while. How about dear old Mum, who you haven’t seen since her silver hair was merely streaked with grey? How about Dave, your best friend from college, who has been trying to get in touch with you for . . . could it possibly be 15 years?
Step 7
… but don’t injure them in the process.
This is not an exercise in self-actualisation at other people’s expense. That’s what you’ve been doing up until now. This is about acknowledging your faults to the people you’ve hurt without hurting them more. When in doubt, keep your trap shut and just sit at home feeling bad about yourself for a while.
Step 8
Replace work with other things that give you satisfaction.
This may be the most difficult step of all. I’m so far away at this point that I can’t even tell you how to approach it. Perhaps, for people like you and me, there’s a sunrise out there that will be as wonderful to behold as the closing documents on a killer acquisition. I hope so. Truly I do.
Step 9
Carry this message to fellow workaholics and make yourself available in their times of need.
That’s pretty much what I’m doing here today – asking you, right now, to sit down, take a deep breath and stop. Try to see a future beyond the random motion of your daily affairs. And in the silence that surrounds you, ask yourself: is there something I should not be doing? Imagine yourself there. Take that first step. But check your email first, okay? You’re paid too much to sit around reading magazines all day, you know.
How your work ethic is ruining your life
It’s easy to understand how men becoming workaholics. “The expectation to excel and be the breadwinner leads to excessive focus on achievement,” says Dr Diane Fassel, author of Working Ourselves to Death. But what about the hidden costs? Here’s what to expect if you maintain this schedule:
Obesity. According to a 2006 survey published in the Harvard Business Review, half of all workaholics don’t exercise enough, and two-thirds don’t sleep enough. Neither scenario is good for your BMI. A study by Case Western Reserve University in the US revealed that people who sleep less also eat less – but gain more weight.
High blood pressure. People who exceed 50 hours of work a week are 29 per cent more likely to have high blood pressure, and are at higher risk of heart disease and stroke, according to a 2006 study from the University of California at Irvine.
Heart attack. Men who work 60 hours or more a week are twice as likely to have a heart attack as those who work 40-hour weeks, according to a 2002 Japanese study by Kyushu University.
Divorce. Women married to workaholics are less emotionally attached to – and feel less desire for – their husbands, according to research at the University of North Carolina.
Messed-up kids. A separate University of North Carolina study found that children of workaholic fathers have significantly higher levels of depression and anxiety.
– Anna Maltby
Sunday, November 15, 2009
It's Sunday, A weekend passed by
Yeah, it is sunday. Usually when sunday comes I feel weekend passed, and another fresh week with full of work going to start in few more hours.
However, this weekend is slightly different. Weekend passed, but even the weekend was full on. Same as the weekdays. I have worked 63 hours this week. Project is getting busier, expectations are high, so as the responsibilities.
.
When I'm old, one day I can sit back and read this. Oh.. Silly me!!
Monday (10)
Tuesday (9)
Wednesday (11)
Thursday(9)
Friday (12)
Saturday(8)
Sunday (4)
However, this weekend is slightly different. Weekend passed, but even the weekend was full on. Same as the weekdays. I have worked 63 hours this week. Project is getting busier, expectations are high, so as the responsibilities.
.
When I'm old, one day I can sit back and read this. Oh.. Silly me!!
Monday (10)
Tuesday (9)
Wednesday (11)
Thursday(9)
Friday (12)
Saturday(8)
Sunday (4)
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
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
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
Subscribe to:
Posts (Atom)
