Thursday, December 17, 2009
Last Words...
And what is more awesome is to receive praises from these experts - similar to hitting 500K in Bejeweled Blitz hehe. During the last day (btw I'm proud to say i didnt cry!), one of the leads commented he has no idea how I managed to do these things when I was never in a single BRD (business requirements discovery) session and I also dont do ETL/OLAP development. I said I was just guessing from what I see. 'but your guesses are always correct'. So fun. :D (thank GOd I probably didnt have much booboos).
So that's it, I'm leaving this behind to do something else. Scary. Back to 0. Still the same goal: I want to retire!!! :p
Funny that I actually took time and managed to write down something related to work. DWH/SQL/data - whatever it is, it has become a part of me for the past 6.5years. I might not be vocal or expressive of things I appreciate. For the last time, I give credit when credit is due. Thanks for keeping me company and making me happy.
P.S. The time I speak the truth might be the time I bade goodbye. *sobs*
Data Checks (2 of 2)
1. Most common issue is PK/integrity checks.
If there’s only one PK (natural key) stated in IFS specs, then IFS should not have two entries with the same natural key, this would result in Oracle constraint error during loading.
Product Code Desc Product Type
1 Class A 001
1 Class B 002
Possible course of action:
1) It could be source issue. Ask for Regen
2) Recheck data model. Maybe there’s a need to check whether natural key is defined correctly. There’s a possibility to explore addition of another new column, (eg. Product Type) which should be part of natural key to determine PK.
2. Not null columns.
Whatever primary columns or columns defined as not null in IFS specs, these columns should not be null in IFS.
Product Code Desc
1 Class A
Class B
Possible course of action: Ask for Regen
3. Unknown codes in Fact Tables
Logically, whatever codes submitted in Fact files should be present in Code tables, or else this would result to lookup failure:
Fact IFS:
Month Product Code Amount
200910 1 500
200910 3 400
Code IFS
Product Code Desc
1 Class A
2 Class B
Possible course of action:
1. If unknown code in Fact IFS is valid (product code = 3), then Code IFS should have regen.
2. If unknown code in Fact IFS is invalid, then Fact IFS should have regen.
3. Or customer can decide that it is ok to keep it as is.
4. Different Cases/Forms that cause mismatch during lookups
As pointed in above point#3, logically, whatever codes submitted in Fact files should be present in Code tables, or else this would resolve to lookup failure. However there are times that manipulation is needed in ETL side to make the join to be successful. Eg: functions like: UPPER, LOWER, TO_CHAR, LTRIM, RTRIM, SUBSTR, ABS, etc.
Fact IFS:
Month Product Code Amount
200910 101a 500
200910 000203B 400
Code IFS
Product Code Desc
101A Class A
203B Class B
Closely looking at the values, the values do exist but not exactly in the same form. This should tell you that these are not really lookup failures.
Possible course of action:
1. Agree with client who should change which and what should be handled in ETL in their side or our side. Other than the agreed things, then whatever that still fails lookup is considered ‘valid’. Revisit the logic when more data has been loaded. Document such to have reference in the future.
5. Volume of Data
The volume of data should more or less be consistent. If a fact file contains 3M records on a daily basis, then it shouldn’t fall too low, eg 100k records. For additional info, data volume is tracked for several other purposes. This is usually checked in SIT.
a. One is for tracking performance: comparing ETL processing time against different IFS files having different data volume.
b. Another purpose is for is tracking compression (in comparison to aggregated tables), this is to check whether compression targets are met or not. If targets are not met, then there is a need to revisit design. Some columns might not be suitable to be part of the group by clause.
Possible course of action:
If IFS file suddenly has too low rowcount, it has to be informed to client to check from their source. This might need IFS regen from M1.
6. Other Common IFS Issues:
• Duplicates - same entry of exactly same records are sent twice.
• Default values. Default values as indicated in IFS specs are not followed. There are also cases where agreed values are Y or N, but in actual IFS, it is showing null values, X values, etc.
• Missing footer record. ETL program from M1 side has to be completed, and thus trailer record will be populated.
• Column length too long.
• Missing or Additional column in IFS
• Extra spaces for data some columns in IFS, special characters.
• Invalid filename
Data Checks (1 of 2)
Scenario: Amounts do not tally.
1) Open the report in UAT instance. If specific account number or cust is given, search for that number. Replicate the issue for those accounts/CIFs raised, you can bring in other fields into the report (eg Sector Code, Sub Product Type, etc) if you need more information.
2) Check how the amount is calculated. The amount field can be an OLAP variable, look for the specific table.column in ETL that is used and do the calculation manually. If it’s a direct fetch from EDW, then query the database.
3) Next is to query the source itself. If it’s a lookup field from another instance, then look for specific join conditions in actual ETL mapping. If let’s say all your amounts are null but in Raw has value, then something is wrong in EDW. Either it’s an ETL lookup issue related to data, or requirement itself is wrong.
Eg: Issues:
- All debit fields are null because debit stream lookup to VBM in ETL in incorrect
- Some FD Credit balances are not matching and consistently lower in OLAP than in Raw, because VBM lookup in ETL has a component for renewal counters, and this field appears differently in VBM and GFDR and has to be padded with 0.
4) It could also happen that for some of the accounts match, some do not match, and there is no data format (trimming, padding) issue or ETL lookup error. This would mean that some of the filters (in either ETL side or OLAP side) are not proper
Eg: We had issues wherein we actually have to modify the filters, upon investigation that something is consistently wrong in our side. Sample issues:
BO: add filter to include Accounts Closed within Current Month. Remove filter on Receipt Status is Closed
ETL: remove filter on sub product type = GT.
Net, it can happen that requirement itself is incorrect. There are times when we cannot fully rely on what is stated in signed off mapping specs/report specs.
5) Another way is the comparison of total number of accounts. In this project, we normally go by account. Get the total number of accounts in OLAP vs the total number of accounts in Raw.
- It can happen that there are MISSING accounts from Raw but in EDW we take them in.
- Or the other way around, there are EXTRA accounts from Raw but in EDW we don’t have. With this, then you have to extract the accounts that are missing/extra, justify why it is or it is not there in EDW. Then do analysis and find a pattern where possible.
Apples and Oranges
In a dwh project, usually there will be some existing reports from old system to be compared against a new EDW. EDW will consist of ETL (processing source data and implementation of all data transformation) and OLAP (reporting layer where further filters and metrics can be applied). With this, data accuracy will be challenged and it's troublesome to find which part exactly has data gone wrong. Sometimes numbers can be critical, especially in banks. These numbers appearing in the report are read by Marketing or Sales people for their forecast, or even CEOs. A cent lost has to be digged out.
In layman's terms: my edw has 20 apples (15 are apple pies, 5 are apple muffins) and 30 oranges (10 are orange pies, 20 are orange muffins). Existing report shows 30 apples and 30 oranges. Somewhere data has gone wrong, it maybe during tagging of pies and muffins or it maybe there is a certain formula for classifying what is a valid apple and a valid orange. Literally comparing apples to oranges. (I hope it gives a better idea now) :D Depends on the type of project, if numbers dont tally, normally it can NOT go into production until the culprit is found. Or sometimes maybe the existing report is actually wrong. Or sometimes the business requirements are not correctly captured. Endless possibilities.
I'm actually not a SQL expert. I can only do simple queries and subqueries, not the too fancy ones. Think about it, it's quite fun to do those intersect, union to extract the correct data that you need in order to find the culprit.
Wednesday, December 16, 2009
Q409 blues
November was also my mom's bday. For a change, I wanted to surprise her. Thank God there were friends who helped to realize this. It's the first time I thought of giving her a 'real' un-informed surprise. I scheduled 2 deliveries within the week courtesy of Red Ribbon, for both her real and lunar bday. Her reaction: priceless. My reaction: bitter sweet. :(
Christmas and New Year. It's always my most favorite holiday, discounting the fact that the most painful things also happened the same time many years ago. Now it still pinches my heart a bit to see the beautifully-lit streets of Orchard now packed with even more glamourous malls, with me alone walking, even if I have companions. Strange that the emptiness doesnt get filled by just anyone. (Cool, serves me right) By the way my hausmate was homesick one day and sharing her memories of having christmas trees. Unfortunately I cannot relate, coz I never had one back home. (okay let's not dwell on difficult lives in this post :p) Passed by a store and thought of buying this 'snowflaking' crystal ball, a slight attempt to put a little decor in my room. :)
It's confirmed, my newest nephew coming sometime Feb is a boy! My alagas will be increased to 4. !!!
And I thought my previous offices are already big MNCs. (or maybe I also cannot directly compare the offices). It's quite exag to see the dual monitors per person in each spacious cubicle in the new office (one monitor seems not enough, they want the comfort of dragging screens in 2 display monitors) For me it doesnt matter, most important is I dont want laptop! I dont want carrying heavy stuff to and from office anymore :p, i dont want bringing any work home. so just give me my desktop hihi! Same goes with the hearsay of 2ksgd ergonomic chair we're sitting on (?). I feel barbaric, like coming from mountain inhabitation. Vain, but I like. :D
I just realize how much I love sql and data analysis, now that it seems I wont be doing much of it. For only this once in my career, I felt a sense of accomplishment. It has become a part of me... now is the time to recount our memories, before we go separate ways...*sigh* I will blog in detail in next post.
Friday, November 27, 2009
Eco Tours
Random Thoughts Oct'09
I finished watching the korean series hit phenomenon Boys Over Flower last month. (This is the korean version of Meteor Garden). Just one thing, it doesnt matter whether it's korean or taiwanese or japanese version, my heart goes to Ji-Ho/Hwatselei/Rui. When the whole world goes crazy over Gu Jun Pyo, I still like Ji Ho more. Well I cant say I dont like Jun Pyo (no normal girl wont be attracted to this manly creature), and I also dont have much inclination towards authistic people, just that he has one quality.. the ultimate 's'. Watch the series and see for yourself.
Because of this, I started researching this hottie KHJ. Quite young, he's born in 1986. He's the leader of SS501 group and oh my, he dances so well, the dance step with the shaking of jacket in the song 'Im your man'. Well cant understand anything except when he shouts 'Im your man', translation would be much welcomed. Whew cant keep my eyes off him. (ok ok too much bs) Here's a link. http://www.youtube.com/watch?v=bxu94q7HWew&feature=related
Haayz I took Korean and I can't understand the lyrics. I took French and gave back half. Now I just finished Japanese, yes nihonggo dear, dozou yoroshiku. Ask me now, before I return all of it again. Well at least I master 4 languages from birth then learn 3 extra (barely basic level, nothing to boast of), that brings my total to 7.
I attended my friend's bday party few weeks ago. There I met a French couple. I was able to use my 'Comment talez vous' and 'Aunshante'. (the spelling is not reliable) The french guy said my accent is ok, he can understand me. Note that French has one of the hardest intonations. I feel flattered :p See this is how learning a new thing comes handy, you can relate to people in small little ways. So here goes another passion, finally started dancing waltz. Curtsy.
My attempt to find a new job sets in. I rarely have the urge to apply for new job, unless there's a trigger that fascinates me. Hmm like my first company? I just felt like squeezing myself in because it seemed hard to get in. (90% substance and 10% luck?). This time I want to squeeze myself into one of the top XXX, and I dont know any acquaintance working there except for one ex-colleague. The other top 2 places are where almost all my friends are working at. I am not crowd-centric so I didnt try the same companies. What topak is the cause... Prestige, shallow as it may sound. And actually cowardice to be exact.. trying to let nature decide its course. Running away. Or maybe, just maybe, this is actually what facing reality is about... There are always 2 sides of a coin, it's up to you to decide which side it actually is. I am quite tired, que sera sera.
I was excited the first week, then delay sets in. It's the first time I got a phone call that is neutral - i was not rejected nor accepted. In short, the rule of elimination is there. Probably I'll stand a very minute chance if they cant get anyone, and the waiting timeframe seems indefinite. I am not satisfied with my interview answers either. I have an expression disorder. Thoughts, actions and words don't jive at the same time. I'm not good in putting my best food forward. Well, there are other major booboos in my life anyway. Maybe the one essential answer that I want to know, till now still cant spit out anything. Big L. (L sign on the forehead). For such answers, I guess it's just a matter of time when I'll be able to tell myself, maybe the answers dont make much difference anymore. :p
There was a day I was late to a dinner get-together, only because Canon in D was played in an orchestra outside a new mall. I just stood there till the piece was finished. I was drawn to the melody, it always reminds me of My Sassy Girl (being one of the OST). One day I hope I can also write an interesting story online.
What should I write.. It should be unique. Interesting. Sweet yet some bitterness. Most importantly with my signature air of depth and non-sensical whim with a twist of suspense that perhaps nobody would understand. Disturbing. Anticipated flop :p A taste of it below.
...A strange dream. I kept knocking. Knocking so hard that my hands bled and bruised. Still the door wasnt opened. The stars that I hold on to, started to become blur. Was it just my imagination? Hallucination? Well do you ever care? It is just me? Probably yes. The echo seems to reckon.
Enough. Reminds me of my friend's fave phrase: P.O.I.N.T.L.E.S.S. Literature suicide hihi
If there are no enough points, then a line segment wont be formed. It's not always that life gives you a line with the arrowhead. Math guru.
Still, is holding on to something pointless considered stupid? I used to firmly believe it's not, now I thought it can be. (but I still am in denial to say it is hihi) Time to live a life, dear princess.
Speaking of, I have a severe hallucination disorder. Like for one, I always would like to feel I'm tall. Then suddenly I looked around and notice just within my circle of friends, I can already name 1 or 2 girls taller than me, and they dont feel they are tall. All these years, I chose to think I was tall, which now I think I have to brainwash myself all over again...unlearn and relearn.
Few months ago I queued so long in a bank for some transactions that later prompted me to write my first letter of complaint online. Onlife stuff works amazing here. I did get a reply within close of business, apologizing and saying they will investigate. I related the same story to my achi. I was really waiting for her to say I'm bitchy. She just commented on my well written letter, told me I have a talent. Then asked me 'Gago, what's your problem??!! lo-siao!@#$' Haha gago is a sign of endearment for us. The whole story was I lost sleep the night before, then had to wake up earlier that morning to go to the bank, queued so early and soo long with an inefficient queue handling system, then rushed to office and missed the bus, paid much for a cab, then was late for a meeting. It doesnt justify anything for bitchiness :p, just that we are human beings. I get pissed off too, dont push me. Waah I should be thankful there are still a handful of people who can tell. Or who simply chosed to believe. Even if I dont say a word. Thanks for blurting out the words for me. Things are not always proportional to what is seen or heard. We are all just mere elements of fate and logic and emotions. And sometimes not everything has an explanation. Watch 500 days of Summer.
I am in my petix mode, project's about to end. Addicted to FB games during office hours. Bejeweled Blitz, cant help but to play the one-minute game and try my luck to strike the top1 spot. Farmville is also nice, I fancied one thing there, that keeps me planting everyday. Havent played the more famous Mafia Wars or Resto city, not too much into games with 'interaction'. May not be so obvious, yes I'm anti-social, I finally realized I'm one, whether you believe me or not.
Recent gadget update: finally bought ipod. As mentioned previously, just to experience the feeling of the 'wifi'-enabled city of SG. Unfortunately, I'm not using it quite often for wifi, unlike people who update fb statuses every hour. I dont seem to have a gadget appetite, not fancying anything new, even the iphone 3gs is not enough to lure me for a 2-yr phone contract. Probably iphone 3gs is a good instrument for status quo, however I'd buy something else if that is the purpose. *wink*
I'm still enjoying the scents in my room. Last month is lavender, this month is jasmine. I wonder what to put next.
I can get satisfaction from a simple task as shampooing. I'm addicted to newly washed hair, even more to fan-dried or blow-dried hair. It sets a good mood, a good start for the day if I'm able to feel my hair fresh and dry. Sheer happiness and also the cause of tardiness. (it rhymes)
Polda-dotted, that's how I think I looked like. Went for a massage few weeks ago. The masseuse was so eager to do her salestalk for 'cupping' (pa kuan). Google it, it's a form of ancient Chinese detoxification therapy where you have empty bottles on your back to suck the toxins out of your body, via pressure valves. (orig is via fire, but that's not too commonly administered now ) Since it's free, I nodded and didnt seem to expect the trouble this would be bringing me. Holy cow, it was one hell of a painnnn, I felt like being severely beaten and punched. After the therapy, my whole back and neck have big, dark red swollen circular spots. My hausmate teased me, the marks look like .. love spots? I laughed and said, 'I think being sucked by an elephant would be more suitable lolz!'. Whoooa it took 10 days to fade all these polka dots, I felt pain the first few days even when lying down or sitting. I dont think I'll be doing this again. Well after a few days, it did give sort of a relaxing feeling. But the whole process, overall I dont think it's something worth doing regularly, I'm too tired to go through hell to get a little taste of heaven. (here's a cropped pix, quote me I normally wont go backless for a self-taken pic - too crazy, just that this is a waste if not captured)
I behaved well this year, didnt keep going to Manila for vacation like last year. Maybe, there's not much difference anyway. I underestimated and overestimated several things, really.
It has been a different year. One simple thing. The world will not stop revolving. It's up to you to keep up. I tried so many things, avoided a few things. In the end, it's not so easy to pick up where I left off. It takes courage, and I dont seem to have enough of it right now. I play with numbers everyday in my work, however age is not one of those numbers to play with, I know.
If life can be as simple as just dining in a nice place, taking some fancy pictures, the world would be such a happy place isnt it. =)
Tuesday, October 27, 2009
Song for the Day
It's been playing in my ipod over and over again. Yes I bought one last month, just to experience the wifi-enabled city of SG, where everyone feels it and I still don't. I am barbaric.
I'm hooked with the melody. Even if you don't understand the lyrics, listening to it gives u somewhat a surge of emotions. (Disregard the video, I personally think the song is much more meaningful than the video content)
http://www.youtube.com/watch?v=KmQJcIw7fAA
灰色的彩虹
我從秋天等到 安靜的落葉
還不夠時間 倒帶想念
就像電影情節 最後完結篇
褪色的畫面 沒有笑臉
我的記憶搖晃著昨天 我還有感覺
一抬頭什麼都看不見 雨後的無言
紅橙黃綠我都找不到的晴天
從此 我們兩個世界
在灰色季節漸漸忘記你的一切
過幾年 我在原點
彩虹出現 而我再也找不到
美麗的蝴蝶 偏偏飛不上天
對你的想念 再也寄不到
你世界 地址是再見
P.S. If you manage to understand the lyrics then this somehow describes how I feel before taking the chapter tomorrow. I'm living to my name of 'nature girl', the lyrics mostly pertain to nature elements. I'm going to be hooked on this for some time I think. It's a hook that I throw myself into...
P.P.S. The hardest word to say.. it's not Sorry, not I Love/Hate You. It is Goodbye.
Sunday, October 4, 2009
Jargon
Here I am trying to understand some fin/fx jargon to prepare for a 'testing the water' day tomorrow. If I respond fast enough, then I might be 'considered'. Booh.
There's only one thing in my mind from the very first day I stepped into the corporate world, the IT world to be exact... I like the job but I STILL want to RETIRE EARLY! haha.
I am really not confident in this.. I have a feeling this is not gonna work. Worse comes to worst, please join me for a few drinks and ice cream tomorrow.
Still, I tried and am trying my best like any other encounters in my life.. 要不起就可以不要了嗎??
If I am to write a song, that would be superb lyrics. =p
Saturday, September 19, 2009
The Simple Things
The best-tasting siomai I've ever tried. I discover this in a little store across my house here. Too bad the store opens only during mornings till 1230. It only costs 0.60sgd per piece (considered cheap here)
I so much like this Polo bread (Po Lo Pao), this is quite popular in HK. It's a soft bun with a not-too-sweet crust designed to look like a pineapple. Note that only a few bakeries here have it (well the most famous Bread Talk doesnt sell this). The nearest bakery to my haus only produces a small quantity of Po Lo Pao, hence again this is one of the reasons to wake up early and rush down to get hold of one.
Strolling is the next best thing on a lazy afternoon. The clean river, the bridge, the dollhouses (aka mansions), the sunset, the lights view at night. Hmm hmm.. if only parks in Manila are not just meant for dodongs and indays.. and if rivers can be much cleaner.. lolz
I seem to have developed a new addiction for soft scents (not the dizziness-inducing strong air freshener in cars). I now have a regular supply of something nice-smelling to hang in my bedroom. The scent, with my bed and
blanket.. all hates to part with me every morning.
The new lamp, Just the right hues for night mode. (the lamp has disappeared with my high-tech cam :p)
Monday, September 14, 2009
Heal
...I'm guilty to have my own share, once in a while.
I was listening to radio the other day and heard this song ranked as #1 in the weekly hit chart. Melody is nice and the voice is very 'clean'. I immediately searched in web and to my surprise, the singer is... handicapped. He is blind.
http://www.youtube.com/watch?v=fvk7EZdpHJM
The video is about a lady grieving over her failed relationship. And as she narrates and seeks comfort from the singer, she's also describing to him what colors are there in this world. The dialogue goes:
Lady: (after consolation)
The ocean is blue.. The sky is white.. The tree is green.. The flower is red. I'll paint love with color.. My smile is a spectrum of colors.
Singer:
My ocean is pitch-black. Sky is black. Tree is also black. Flower is still black. However, it seems like only love is white in color.
The mandarin verses of course are much more meaningful (I just made a literal plain translation). I felt moved by the song and the video. The singer happens to be a main guest performer in the previous National Day Parade. I admire his determination to inspire people with his talent as a composer and performer.
Maybe as long we have eyes to see, have feet to walk, or just being able to breathe, is there really a burden too drowning to let us down. Something to lighten us up.
Monday, August 10, 2009
Malacca day trip
The most popular landmark in Malacca is the Melaka Church, situated in Dutch Square.
Other remarkable pix are:
Statue in a Chinese Temple (which I forgot the name)
Jonker Street
(reminds me of my hometown, this is how Binondo looks!)
Trails of Baba and Nonya Musuem
-these are the descendants of Portugese-Chinese. They are known for the beaded handicraft artwork (which by the way is very expensive as they are hand-sewn piece by piece). And also quite known for the Peranakan cuisine, which is as spicy as you can imagine.
Bakery (interestingly named Sha Shu Kong, meaning 3rd uncle)
On the trip back, I was watching Jet Lee's 'Fearless' movie on the bus. It has been so long since a movie has made me teary-eyed (or was it because I was feeling low and down then). Anyway, I was moved by the character of Jet Lee, of how he transformed from an arrogant fighter into understanding the true essence of winning. A lot of things in life are not what they seemed to be.
P.S. Finally back to blogging mode. I was surprised to see thousand+ hits in Adsense (although of course it only has a few cents lol). I'll try to lessen the 'emo' posts in the future :p
Strange Images
Remember the usual puzzled look you'd see on cartoons, like three strips of sweat dripping on the forehead, and some question marks appearing all over the head? This will make you recall that expression. That's why conversing in Mandarin is preferable at times.
Cookies and Creme flavors for ice cream and cakes are certified crowd favorites. However, I never thought of having it on my hair during a hair spa session. Another killer - special bundle of joy? I only see the phrase used by excited parents welcoming their newborns, other than that, this is the first time I've seen it used elsewhere.
P.S. No offense for any sarcasm for the last 2 images. Kasi pinupuno lagi ang mailbox d2 ng flyers. I hope they dont have blogs and dont read blogs. But anyway think of the bright side, this is free online advertisement :D
By the way, I have added one more resto to my previous blog for Best Kept Secrets. Once I have the time, I'll showcase some more foodie trips.
Sunday, August 9, 2009
What's Cooking 09
(the secret is simple, marinade)
Best Kept Secrets: Food Reco
So here goes my urge to share some of the restos that I recently tried and would recommend. The best ones are usually not located inside the malls, it's for you to uncover these best kept secrets. And another important thing, there is definitely a long queue! The longer the queue, the more it arouses my curiosity - anong meron? pila rin tayo. :D
Uncle Leong's
As mentioned, known for crab beehon, an alternative to the usual chilli crab and black pepper crab. If you are not a spice fanatic, this one's for you. The crab is big and the meat is firm. The soup is so tasty. This is just located in a hawker near AMK, not a fancy resto. The other dish is deep fried prawn in salted egg (but I personally still prefer cereal prawn over it).
Vines
I like the ambience of this resto, it's just so homey and it actually resembles some restos in Phil. Light is a little dim, music for chillax, ideal for dates actually and the most important thing is I like their famous BBQ Pork Ribs (which is ranked among top 100 dishes by some orgs) And it's quite cheap. I find the steaks better than Tony Romas and the price is just less than half. There are times when you just want to have a good meal with good company, and you wouldnt really feel like splurging all the way - so this is the best place to be.
Founder Bak Kut Teh
I'm not a huge fan of Bak Kuh Teh, I seldom order it. However so far this is one of the best tasting bak kut tehs that I've had.
Loy Kee
Actually I cant distinguish much what is a 'good' chicken rice :). I just know that this is one of the famous chicken rice restos in town, next to the famous Boon Tong Kee and Wee Nam Kee probably. The chicken is tender and juicy.
Those that didnt quite make it to my fave list:
Ajisen-Ramen
I dont know why there are so many branches of Ajisen-Rames all over Asia: Singapore, Malaysia, Thailand, HK, China, Macau, etc. I actually didnt find anything outstanding (or probably I'm not ordering correctly?) I find the ramen soup too oily and salty.
Xin Wang Taiwan Cafe
One of the popular Taiwan street food is their breaded chicken chop. This one's really a huggge serving and I finished it. Pair it with milk tea with sago - Perfect
Xin Wang Hong Kong Cafe
And the equiv for the staple food in HK is none other than HK baked rice or baked spaghetti. Quite ok, just that usually the cream tends to make the dish too 'nakakaumay'. Pair with nai-cha (milk tea) and it sure's gonna create some sensations in your mouth.
Soup Spoon
For me this is an ideal place to go when you have colds. When you are in your sneezing mode and you feel like drinking a hot healthy soup with veggies (like minestrome or chowder), this is the place to go. A typical order is a soup with a french bread, cost about 12sgd.
Zhou's Kitchen
I saw it in one of the reviews to be great, one of the famous Chinese dimsum in Novena. The best seller is some siomai soup. After tax, each small bowl costs more than 17sgd+. I didnt find it worth the raves.
Updated Aug 13:
Deli Moroccan
The best place for moroccan dishes, try their kebabs. A big serving costs only about 10sgd. You can also try the freshly brewed mint tea, which gives you a strong toothpaste aftertaste - unique. (though I dont feel like consuming it often)
Saturday, August 1, 2009
Testing
都已經過了兩個月了,
可我心裏有時還是七上八下的.
怎麽有一種被惩罰的感覺 :-<
這次真的考倒我了 真希望...
Monday, July 27, 2009
Nothingness
Pasalubong
Some of my favorite pasalubongs in my last trip:
Mom's blouse - I got attracted by the brooch-like sewn design the first time I saw it and the cut of the blouse, however the blouse was twice my budget so I left without buying (I previously already bought a few pcs for this uwi but not as nice as this one). Few weeks before my flight, I again went to my usual shopping place and saw it again. Cant resist anymore, I know it'll look good on my mom. I specifically told her to reserve that for special occasions only *winks* demanding.
Nephew's shirt - I am not a big fan of any cartoon character but this one really caught my attention. I saw it on sale and dug my hand so fast. Just so cute both graphics and message. I think I better stop buying too kiddie stuff as my nephews are already in grade school
'Lag'
I somehow have a 'lag' in terms of price range and fads nowadays in Manila. I'm still used to what I thought was a 'reasonable/practical' price of commodities and services before. If you're away for 2 years+, then you'd feel the surge in prices, inflation in Philippines. My sister was laughing, 'dapat nga sanay ka sa mahal eh'. I answered 'sa SG oo no choice eh, pero dito parang weird!'
1. I went for dental tooth filling (pasta) and was charged for 1500phhp for 3 teeth. I used to pay only 300-350php for each before. I complained at home and my sister said, ''pasalamat ka, I just had mine for 700php each!"
2. I was asked to treat lunch at Penang Hill. I used to like their food before, but it wasnt on top of my list for the reason that I can taste any of their bestseller dishes in the hawker anyday if I want to. However since my companions seemed to be craving for Makan food: here goes Roti Prata, Beef Rendang, Thai Tom Yum, Char Kway Teow, Fish Curry. Hainanese chicken was out of stock or else 'all present' talaga. And that point in time I was craving for Jerry's Grill hehe, well not really a mega huge fan of Filipino food. Anyway, since I enjoy being in the company of people na nasa mood kumain, so cge pagbigyan. Since there wasnt any expensive seafood at all in the bill, I was a bit surprised that total charge was like more than 1400php. Mahal na rin pla mag-eat out sa Manila.
3. Jollibee - a place I always have to pay 'courtesy call' to.
One-pc chicken spaghetti meal with drinks is now 100php. Gone are the days where 50php was sufficed for a chickenjoy meal. One-pc chickenjoy meal with drinks is 82php. Anyway, I still enjoy eating at Jollibee. As my friend reacted, if a fastfood meal costs 100php, magkano na ba ang allowance ng mga students ngyon sa Manila?
4. I havent received a bday cake in quite some time. Finally got a Mango Bravo from Conti's, which I heard was popular. Lame first-timer. It was good.
5. A friend told me membership at Fitness First's gym is now at 2600php/month. 2 years back, I know it was only 1200-1500php. It doubled.
6. My sister got a free voucher for massage and pedicure from The Spa, which she wont be able to use and gave to me. I havent been there before and I know they charge above average. Anyway it's free so I went there to pamper myself. I checked the worth of the vouchers: pedicure 380php, 1hr swedish massage 820php. Quite high especially the pedicure! After the pampering session, I further walked around the mall and saw a lot of familiar shops that I see in SG: Wade, Aldo, Iora, Topshop/Topman, Dorothy Perkins, Promod, etc - the prices are similar actually at 2K+php. (2k+php seems more exorbitantly high than seeing 70sgd? :p),Seems like spending level has gone up in Manila.
7. Kelan pa nagsulputan ang mga Savory Chicken branches in malls? I havent noticed this before. A briliant step to franchise a classic indeed. I used to order chicken and lomi from their main branch in Escolta. Bigla ako nagcrave, that's what I requested to be ordered in my yummy byebye dinner, with Mom's home-cooked seafood dishes. Party time.Lag na, d ako updated.
Counting
Because of the recent stories related to sickness shared by people around me, I suddenly became aware and conscious of life's predicaments, i.e. gynaecological-related.
I used to have a classmate before who was the ultimate boy magnet, crush ng bayan, the type whom ordinary girls (like me) would admire. This girl was already engaged 4 years back, and yet mysteriously, her wedding was called off by the guy's side. It was like 'omg, what went wrong, jackpot na pinakawalan pa'. It was only late last year when I heard of the reason... The girl went through some operations with mattress (uterus)-related problems and have implications on birth-giving. The harsh reality.
and I initially thought such disorder was rare, .. seemed not.
I recently heard of few couples who were married for years and wifey not pregnant till now. I guess such situations are tough. Irregular menstrual cycle, polycystic cases, in vitro, etc,
So what sums up the essence of a woman:
At age >24, question: kelan ka ikakasal?
After marriage, question: d ka pa buntis?
*Additional for the old-style FilChi, question: wala ka pang anak na lalaki?
:)
Well I guess the essence of a man doesnt sound so easy too, add to above: earnings? cars? house?. so life is what.
Anyway, as my mom puts it, better 'pay tuition to buy peace of mind', referring to having check-ups for prevention. Note that it was heavily raining in Manila the whole week I was there, and I got to experience typhoon signal#2 again in a very long time. Despite so, I still dragged myself for an ultrasound. (read: ultrasound is not for pregnant woman only, it's for checking whole upper and lower abdomen with all the organs). I hope to see results as 'cleared'.
The nurse/technician who assisted me seems like a baguhan. I dont know if it was SOP as she asked me so many questions. It was my first time so I also had no idea. Suddenly she pointed at the screen and counted aloud '1, 2, 3, 4, 5, 6...'. I was like 'what???', i suddenly felt some numbness. I asked her 'may nakita kayong cyst?'. She answered 'ahmm ahmm, wala naman'. I asked again, 'normal ba'. She said 'antayin nyo na lng yun result bukas'. Hmm I'm not feeling lucky nowadays, I really hope there is nothing serious.
The next day I went to get the results. Despite the medical jargon, I didnt see any familiar word that should be a cause of big panic. The only '6' I can see in the results is the measurement of some organs like 1.6*1.9*2.3 etc, so I guess she was counting the centimeters from a ruler bar in her screen? I felt somewhat relieved and went for the doctor's diagnosis. All's well that end's well. (If not, I wont be blogging about it here). Loko lng si nurse :p. Anyway, that's a reminder for all the women and girls (once you have your period), it's always better to be safe than sorry.
The Young Days
I live in Binondo, studied in Binondo both elem and HS, and the whole stretch of Masangkay and Benavidez, memoryado ko with closed eyes. I went there for an errand and ended up buying all the street food that I can see. It was years ago when I passed by there.
- Fishballs, Kikiam and Kwek Kwek outside St. Stephen's
- HK style pan-fried noodles in Eat Fresh
- Fresh boiled corn outside the chapel near Metro Hospital
- New store: pancit malabon from Tunay na Pancit Malabon
- New store: fresh bibingka (i forgot the stall's name)
too bad there was no dirty ice cream that time.
If only my stomach could still fill in some more food - there were Suzhou dimsum and Lan Zhou La Mien across Metropolitan Hospital. I was surprised to see Goldilocks and Red Ribbon in the same vicinity too.
I was amused to see another new condo in progress right across St. Stephen's High School. Metro Hospital now looks superb and 'sosyal', far from the shabby building it used to be. It even has Seattles's Coffee house inside.
I also got to try some of my fave Binondo dimsum houses again while meeting up with a few close friends who bothered to take time to see me:
- Wanchai
- Tasty
- of course Wai Ying
- Xiao Chuen Yuen
It was like time travel.
Ending line:
I heard this line from someone before...'where nothingness is everything, and everything else is nothing'
P.S.
都已經過了兩個月了, 可我心裏有時還是七上八下的.
怎麽有一種被惩罰的感覺 :-< 這次真的考倒我了 真希望...