Subscribe via Email

Subscribe to RSS feed

How to create result source in SharePoint 2013

In the last project, I was assigned to build and configure the search center. Thanks to teammates’ help and googling, I’ve get more and more familiar with search center.

When you want to query from one certain type of content, using result source is one of your good choices. In this blog I will demonstrate how to create a result source. Read the rest of this post »

Posted in sharepoint

Informatica: Money Data Type Doesn’t Get Accurate Value in Target

Problem Description:

Several days ago when I ran a PowerCenter session, I encountered an issue of populating column value of money data type from one Microsoft SQL Server table to another. For example, the original source value is 1234.1250, but after I loaded it to another table, it became 1234.1136.

In Informatica, the column data type is set to money in source and target table definition. And we set it to decimal (19, 4) in middle transformations because there is no money data type in transformation.

Solution: Read the rest of this post »

Posted in BI&Database

Current Employee Status with SCD Type 2 in OBIEE

In the star-schema based data modeling, it is not very often to turn on slowly change dimension as type 2, while it will bring some advantage to feed some requirements such as ‘show me the history change for one business group folks’, ‘show me the revenue and cost incurred by the employees at point of time’, etc. All of these require tracking records for the persons. While in this short post I would like to share another type of requirement which is built upon SCD type 2 and my approach of how to resolve the issues – it may not be perfect but will give the OBIEE developers a quick way to GO. Read the rest of this post »

How the Defect Triage Process Helps

In this blog, I will introduce the defect triage processes that I previously defined and show how it can be tailored for similar, future projects.


I joined an integration project to lead and do integration testing after I already did functional testing for the client’s four projects, which were all related to the integration project. I thought it would be easy for me to tackle the integration testing because I have already done testing for these individual projects, and I knew the requirements and business rules quite well. I also have already communicated with the project managers and team members of the APP projects during functional testing.

However, when integration testing started for a while, I found the most challenging work was not about finding a valid defect quickly.  Read the rest of this post »


Posted in Testing

What’s a Mobile Simulator? An Intro to iPadian

What is a Mobile Simulator?

A mobile simulator is a software application for a personal computer that creates a virtual machine version of a mobile device, such as an iPhone, or other smart phone, on the computer.1 The mobile simulator allows the user to use features and run applications on the virtual mobile on their computer as though it was the actual mobile device. A simulator can be simply termed as a model for analysis. But in the case of an emulator, it can be used on the basis or particle-oriented purpose, or it can be substitution in case of the original device purpose. It is there to give you an idea about how something works.

Read the rest of this post »

Posted in News

Informatica: How to set target flat file name with timestamp


We want to create a target flat file name with the current system date.

Solution 1

  1. The first method is renaming target file name in post session command as bellow:


The following command will rename the file in the format filename_MMDDYYYY.out on Windows:

move $PMTargetFileDir\filename $PMTargetFileDir\filename_%date:~4,2%%date:~7,2%%date:~10%.out

01 Read the rest of this post »

Posted in BI&Database

The Architect Role in Offshore Development Projects

“The best architectures, requirements, and designs emerge from self-organizing teams.”

– One of the agile principles.

The Architect Role in Offshore Development ProjectsWhenever I see an offshore delivery project where the architect is super busy on implementing/coding a particular feature and has little time to communicate with the development team, most likely the project is running into trouble… So, what should architect do in offshore delivery project?

The Architect should act as bridge between the customer and development team

Due to the time zone differences between the offshore team and customers, the onshore architect is naturally responsible for working directly with customer (and business analyst) to define functional and non-functional requirements, including identifying and resolving conflicting requirements.

On the other hand, architect should also work with the offshore development team to ensure that the requirements and the high level design are fully understood by the team. During the development, offshore team usually will ask requirement questions. Architect should be responsible for answering those questions in time.

Read the rest of this post »

How to Use a Mobile Emulator for Testing

When we start a discussion about Mobile browser testing,  we immediately think of testing on a mobile device. I can suggest a different idea. Emulators.

Nowadays it’s very common that people view websites on mobile devices. So Mobile testing is needed in order to ensure testing.

What is an Emulator? Any Guess?

An Emulator is a device which mimics something close enough so that it can be substituted for real world device. Mobile emulators always supports functional output and will tell you visually, what isn’t working on a website. A mobile phone emulator lets you check the responsiveness and functionality of the website across different mobile platforms, such as iPhone, Android..etc..

Emulation or emulators behave exactly like the same device, in order to result in exact output and performance.

Emulator is – it will always take compile code and it will try executing it but in case of

Simulator is – it is very similar to interpreter that is it actually executes the real code in line by line to mimic original behavior of that device.

Read the rest of this post »

Posted in News

Use XRANK operator to boost the dynamic rank in Sharepoint 2013

In this blog, I’ll introduce a novel ranking algorithm called XRANK as a solution to boost the dynamic rank of items based on certain term occurrences within the match expression in Sharepoint 2013.

In the law firm business, there are lots of matters, and the attorneys always try to find out matters which are similar. For example, another matter is considered similar to the current matter according to the affinity for the following matching values. Any match within a tier trumps matches on subsequent tiers, while multiple matches within a tier would serve as a tiebreaker. Read the rest of this post »

Using Selenium with Java and TestNG (5)

Page Factory

In this blog, I‘ll introduce how to use selenium page factory.

Page factory is the way selenium provided to reuse the web elements.

If you don’t use page factory or the page object model, the test scripts maintenance will take too much effort. The problem is that selenium only gives the page factory to us but does not tell us how to design our framework to use it.

Here is my design: Read the rest of this post »

Posted in Testing