DM Checkpoints

1) Try to identify the impact of having multiple charactersets in the Source and Target Dbases.
Query to find Characterset of oracle dBase.

select * from sys.V_$NLS_PARAMETERS where parameter like '%CHARACTERSET%'
NLS_CHARACTERSET UTF8

limiation for Decode() oracle sql function

the maximum number of components in the DECODE() expression , including

expr,searches,results and default is 255.

meaning of word "Shiju" from internet

http://www.orientaloutpost.com/dictionary.php?q=shiju&t=english

Interconnect Billing Concepts

In Telecommunication, Interconnection agreements allows one operator to use the networks of other operators, including their physical infrastructure and software systems. Each operator can give users of its own network access to the user or services of other networks based on certain interconnection agreements. One of the key regulatory objectives in Telecommunications is to ensure that operators conclude such agreements under equitable conditions.

Normally there are two types of agreements(1) Roaming and (2) Interconnect.

In interconnection terminology the other network operator whom we are providing service is named as "Partner", for configuring the same at the BSS platform, one need to provide certain informtaion such as (1) Partner Code (2) Partner ShortCode/PLMN Code (Public Land Mobile Network code (3) Partner Group (GSM/PSTN/CDMA/3G etc) (4) Operational Domain (International/Domestic etc) (5) UTC (Universal Time Coordinate) or Greenwich time (6) POI (Point of Interconnect) (7) IMSI prefix of the partner (8) Partner valid from which date (9) Transfer type(Incoming//Outgoing//Bi directional) (9) Rating Zone (Group of destinations having same rates) (10) and a lot based on the platform you are using.

Macedonian Greetings for Xmas

Good Evening and Happy Christmas Eve ==> "Dobra Veccer I Vesel Badnik"

Christ is Born ==> "Hristos Se Rodi"

Indeed, He is Born ==> "Voistinu Se Rodi"

Display numeric value in words using SQL

SQL> select to_char(to_date(123,'J',),'JSP') from dual;

output as below

ONE HUNDRED TWENTY-THREE

Query to find top 3rd salary in an organisation using RANK function

select empname, salary
from (select empname,salary ,rank() over(order by salary desc) sal_rank from EMPLOYEE)
where sal_rank=3

(From Oracle 9i onwards)

About Managed Services(in Telecom)

Major Advantage/Requirement/VAlue add of managed services operations in telecom sector is that service provider are expected to resolve the problems when they arise or to fix faults before the customers or end users realize there is a fault.

Billing Concepts

Hot Billing//Real Time Billing or Warm Billing//Near Real Time Billing
=================================================
1) Hot Billing //Real Time Billing :--> Processing CDRs within 1 minute of call completion.

2) Warm Billing//Near Real Time Billing :--> Processing CDRs within 5 minutes of call completion.

Telecom Products and offers

Products and Offers
====================
Products (Packages) and offers (promotions) can be assigned (or sold) to subscribers.
A Product is a way of charging a customer during a period and determines what the
customer gets charged at the end of a billing period.

Offers are similar to packages, except that they are valid only for a certain period
and are used to provide special services or rates to the subscriber.
A product /offer consists for following components.
a) One time charges
b) advance rentals
c) rentals
d) initial charges
e) discounts
f) services
g) variable tariffs
h) tariffs (attached with products only)
(Technical services//Profit_Cost centers also attached to offers and products)

Churn

Churn
------

Used in Telcos to describe the turnover rate in the number of
subscribers to a service or product. Churn rate indicates that
subscribers are swithcing to a different service or company,
or eliminating service altogether.Telcos need to keep current customers
happy and to reacquire previous subscribers.

Methods to elimiate customer churn.
-----------------------------------
1)Business promotions with a metric to track its success rate.
2)Loyalty programs

String manipulation using Excel Nested Functions

Convert number +91 (11) 2000-5658 to 20005658


=int(CONCATENATE(MID(B2,SEARCH("+91",B2)+9,4),MID(B2,SEARCH("-",B2)+1,4)))


Happy New Year 2010 to all Blog Readers.