Business Intelligence 101

Data Warehouse is nothing but a relational data base which stored data based on the agreed data model ?

a: True or b: False

What is a DataMart?
--> Data mart is usually sponsored at the department level and developed with a specific details or subject in mind, a Data Mart is a subset of data warehouse with a specified objective.

What is a Data Warehouse?
--> Data Warehouse is a "Subject-Oriented, Integrated, Time-Variant Nonvolatile collection of data in support of decision making".

What is BI?

Business Intelligence refers to a set of methods and techniques that are used by organizations for tactical and strategic decision making. It leverages methods and technologies that focus on counts, statistics and business objectives to improve business performance.

The objective of Business Intelligence is to better understand customers and improve customer service, make the supply and distribution chain more efficient, and to identify and address business problems and opportunities quickly.

Connecting two servers using SSH public keys.

Use the below method to generate Public keys:

On source host server:

Goto to user directory

cd ~
mkdir .ssh
chmod 700 .ssh
cd .ssh

Execute the below command

/usr/local/bin/ssh-keygen -t rsa -b 1024(or) ssh-keygen -t rsa -b 1024

cat id_rsa.pub

copy contents of id_rsa.pub (file)

On destination host server:

Goto to user directory

cd ~
mkdir .ssh
chmod 700 .ssh
cd .ssh
vi authorized_keys

Paste contents of id_rsa.pub into authorized keys (to which ever connecting server)

chmod 600 authorized_keys --(don’t miss this permission, this should be and must be 600)

After completion of above steps execute below command from destination host:

ssh xyz.alpha.com

Till Next time..:)