Tech Bites

Monday, February 8, 2016

Teradata architecture

Teradata Architecture:

Teradata mainly contains the following architectural components.
1. Parsing Engine (PE)
2. BYNET
3. AMP (Access module processor)
4. Disks

Parsing Engine:
Parsing Engine is a virtual processor (vproc).It has the following software components.
1. Session control
2. Parser
3. Optimiser
4. Dispatcher

Whenever a SQL request is given to the parsing engine the session control verifies for the session authorisation (user name and password) and based on that processes or will reject the request.

Parser verifies the sql request for proper syntax and evaluates them. Checks the data dictionary if all the objects exist and if the user has authority to access them.

Optimiser develops the least expensive (time) plan to execute the request .optimiser must know about system configuration, available AMP’S and PE’S. Optimiser enables Teradata to handle complex queries efficiently.

Dispatcher controls the sequence in which steps are executed an passes the steps to the BYNET. BYNET is a messaging layer in between parsing engine and access module processor. After the AMPs process the steps, the PE receives their responses over the BYNET. The Dispatcher builds a response message and sends the message back to the user.

Teradata uses hashing algorithm to distribute rows evenly across the amps .Based on the index column Teradata generates the hash value and based on that value data is sent to different amps. Data having same hash value will be sent to one amp (duplicate data).so depending on hash value data is evenly distributed across all the amps. when index is not selected properly data will not be distributed equally and hence leads to more data in one amp and less in one amp which is called skewness .

Thursday, November 5, 2015

SharePoint 2016 Features

Improved provisioning capabilities
Mobile and touch
App Launcher
New and improved controls
Simple and natural sharing
Large file support
Compliance tools

Thursday, September 3, 2015

upload files using windows explorer instead sharepoint 2013 not working OFFICE 365

Step 1 : Close all your browsers and browse the library that you want to open in explorer.
Step 2 : while login to office 365 TICK KEEP ME SIGNED in check box.

if step 2 : fails

Step 1 : Close all your browsers
Step 2 : Restart WEBCLIENT Service
Step 3 : browse the library that you want to open in explorer.
Step 4 : while login to office 365 TICK KEEP ME SIGNED in check box.

Saturday, December 13, 2014

CSS Menu with SharePoint List Items

Step1 :
Add below css for rendering multilevel menu.

<style>
    /* General menu styling */
    .nav {
        position: relative;
        margin: 0;
        padding: 0;
        line-height: 22px;
    }
        /* The main navigation link containers */
        .nav > li {
            display: block;
            float: left; /* Displaying them on the same line */
            margin: 0;
            padding: 0;
        }
            /* The main navigation links */
            .nav > li > a {
                /* Layout */
                display: block;
                position: relative;
                padding: 10px 20px;
                /* Text */
                font-family: "Open Sans Condensed", Arial, Helvetica, sans-serif;
                color: #fff;
                font-size: 18px;
                text-decoration: none;
                /* Background */
                background: black; /* For older browsers */
                background: rgba(0, 0, 0, .6); /* Transparent background for modern browsers */
                /* Making the color to change on hover with a transition */
                -webkit-transition: color .3s ease-in;
                -moz-transition: color .3s ease-in;
                -o-transition: color .3s ease-in;
                -ms-transition: color .3s ease-in;
            }
                /* Changing the color on hover */
                .nav > li > a:hover, .nav > li:hover > a {
                    color: #0fd0f9;
                }
        /* The links which contain dropdowns menu are wider, because they have a little arrow */
        .nav > .dropdown > a {
            padding: 10px 30px 10px 20px;
        }
    /* The arrow indicating the dropdown */
    .dropdown > a::after {
        content: "";
        position: absolute;
        top: 17px;
        right: 10px;
        width: 7px;
        height: 7px;
        -webkit-transform: rotate(45deg);
        -ms-transform: rotate(45deg);
        -moz-transform: rotate(45deg);
        -o-transform: rotate(45deg);
        border-bottom: 1px solid #fff;
        border-right: 1px solid #fff;
    }
    /* Changing the color of the arrow on hover */
    .dropdown > a:hover::after, .dropdown:hover > a::after {
        border-color: #0fd0f9;
    }
    /* The submenus */
    .nav ul {
        position: absolute;
        margin: 0;
        padding: 0;
        list-style: none;
        display: block;
    }
        /* General layout settings for the link containers of the submenus */
        .nav ul li {
            position: absolute;
            top: -9999px; /* Hiding them */
            height: 0px;
            display: block;
            margin: 0;
            padding: 0;
            /* Making them to expand their height with a transition, for a slide effect */
            -webkit-transition: height .2s ease-in;
            -moz-transition: height .2s ease-in;
            -o-transition: height .2s ease-in;
            -ms-transition: height .2s ease-in;
        }
    /* Displays the submenu links, by expading their containers (with a transition, previously defined) and by repositioning them */
    .dropdown:hover > ul > li {
        height: 30px;
        position: relative;
        top: auto;
    }
    /* The submenu links */
    .nav ul li a {
        /* Layout */
        padding: 4px 20px;
        width: 120px;
        display: block;
        position: relative;
        /* Text */
        font-family: "Open Sans Condensed", Arial, Helvetica, sans-serif;
        color: #bbb;
        text-decoration: none;
        font-size: 16px;
        /* Background & effects */
        background: black;
        background: rgba(0, 0, 0, .6);
        -webkit-transition: color .3s ease-in, background .3s ease-in;
        -moz-transition: color .3s ease-in, background .3s ease-in;
        -o-transition: color .3s ease-in, background .3s ease-in;
        -ms-transition: color .3s ease-in, background .3s ease-in;
    }
        /* Changing the link's color and background on hover */
        .nav ul li:hover > a, .nav ul li a:hover {
            color: #0fd0f9;
            background: rgba(0, 0, 0, .75);
        }
    /* Making the level 2 (or higher) submenus to appear at the right of their parent */
    .nav ul .dropdown:hover ul {
        left: 160px;
        top: 0px;
    }
    /* The submenu links have a different arrow which indicates another dropdown submenu */
    .nav ul .dropdown a::after {
        width: 6px;
        height: 6px;
        border-bottom: 0;
        border-right: 1px solid #fff;
        border-top: 1px solid #fff;
        top: 12px;
    }
    /* Changing the color of the arrow on hover */
    .nav ul .dropdown:hover > a::after, .nav ul .dropdown > a:hover::after {
        border-right: 1px solid #0fd0f9;
        border-top: 1px solid #0fd0f9;
    }
</style>

Tuesday, July 15, 2014

What's new in SharePoint 2013 for a Developer - quick Points

Design Manager
Snippet Gallery
Device Channels
Device Channel Panel control
Display template
Image renditions
Managed Navigation and EMM capabilities with Taxonomy
Content Search Web Part
Design packages
Catalogs
Cross-site publishing
Analytics and recommendations
Variations and multilingual sites

Change FARM Account Password in Central Admin Server

Login to Central Admin server and open SharePoint Management Shell as administrator.

Run the below command (Replace Credentials with your new Credentials of the farm)

stsadm -o updatefarmcredentials -userlogin sp\<Account Name> -password <Account Password>

Have Fun :)

Friday, May 9, 2014

The crawler could not communicate with the server. Check that the server is available and that the firewall access is configured correctly

Error while crawling content source in SharePoint 2013 search.

Resolution : Check the default search crawl account.