PowerPivot Error: user is not a farm administrator - Fix

Fix:

Open Central Admin

Go to View All Site Collections

Select Central Admin Root site collection,

Add the Domain Account as Site Collection Administrator.

Now run the PowerPivot Configuration Tool. It will open without any issues

Horizontals and Verticals in Software industry

Verticals in the Software industry are nothing but domain knowledge related

Examples:
Automotive
Banking
Oil and Gas
Healthcare
Retail
Insurance
Manufacturing

Horizontals are nothing but skills or technologies to develop the software applications

Examples:
SAP
Oracle

Creating LightSwitch Application using Visual Studio

We can easily build business applications by using the Visual Studio LightSwitch Development tool

Click on Visual Studio 2013 > Choose File, New, Project > In the list of templates, expand the Visual Basic or Visual C# node, Select LightSwitch node, and then choose the LightSwitch HTML Application template

It creates data folders and screen folders by default.

You can find data folders in the Solution explorer window

You can find screens folders in the explorer window

Create the entities under data folder.You can Create new table. The Entity Designer window opens.Define your data for your application.

Solution Explorer  choose Add Screen.The Add New Screen dialog box appears.In the Select a screen template list, choose Common Screen Set.Select the entity that you have defined earlier.

Save and Press f5 to run the application.

During you can add/edit/delete/browse the data. You can perform CRUD operations. It is so quick....

Big Data and Hadoop Interview Questions

 Q: What is Big Data and Why it is useful?

 Q: What is MapReduce?

 Q: What is Hadoop Framework?

 Q. What is JobTracker and its main functions

 Q. What is TaskTracker?

Q. What is Hadoop Streaming?

Q: What are the three modes in which Hadoop can be run?

Q:What is a metadata?

Q: What is a Datanode?

Q: What is a heartbeat in HDFS?

Q: Are Namenode and job tracker on the same host?

Q: What is a block in HDFS?

How to process XML data files using Hive of Big Data

Copy your xml data file into your local folder

Now create hive table

Hive> create table xmltable(mystr string);

Load data into hive table from local xml file

Hive>load data local inpath ‘xmlfile’ into table xmltable;

Use XPath to convert the array data into normal hive table data

hive> SELECT xpath(xpathexpression)  FROM xmltable;

How to process JSON data file using HIVE in Big Data

Use Hive-JSON SerDe

Copy hive-json-serde.jar to the Hive server

Copy test,json file into your folder.

ADD JAR /path/to/hive-json-serde.jar;

Create a table

       CREATE TABLE test_json_table (
          field1 string, field2 int, field3 string
       )
       ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.JsonSerde'
       LOAD DATA LOCAL INPATH '/tmp/test.json' INTO TABLE


Write a simple SELECT statement to fetch the data

SELECT field1,field2,field3 FROM test_json_table;

Connecting to MySQL via Sqoop in Big Data

Syntax to import data from any relational database

sqoop import --connect <JDBC connection string> --table <tablename> --username <username> --password <password>

sqoop import --connect jdbc:mysql://ipaddress/db --username <enter user name> --password <enter password> --table tble