Tecxpera Technologies

Informatica

Informatica Corporation is a software development company founded in 1993. It is headquartered in Redwood City, California. It was founded by Diaz Nesamoney and Gaurav Dhillon. Anil Chakravarthy is the company's CEO. The company was founded in 1993. It went public on NASDAQ Stock Exchange under the stock symbol INFA on April 29, 1999.On April 7, 2015, Permira and Canada Pension Plan Investment Board announced that a company controlled by the Permira funds and CPPIB has signed a definitive agreement to acquire Informatica for approximately US$5.3 billion.On August 6, 2015, Informatica announced completion of acquisition with Microsoft and Salesforce Ventures joined as strategic investors. The company's stock ceased trading on the NASDAQ under the ticker symbol INFA effective on the same date.

Types of transformations

Active : One that can change the number of rows being output.
Passive : One that cannot change the number of rows being output.
Connected : One that has at least one link with other transformations or objects in a mapping
Unconnected : One that does not have any link with any transformations or objects in a mapping

Tera Data

Teradata Corporation is a publicly-held international computer company that sells analytic data platforms, marketing applications and related services. Its analytics products are meant to consolidate data from different sources and make the data available for analysis. Teradata marketing applications are meant to support marketing teams that use data analytics to inform and develop programs. In early 2015, the company formed two divisions: Data & Analytics for its data analytics platforms and related services and Marketing Applications for its marketing software and related services.The corporate headquarters are in Miamisburg, Ohio.

Corporate overview

Teradata is an enterprise software company that develops and sells a relational database management system (RDBMS) with the same name. Teradata is publicly traded on the New York Stock Exchange (NYSE) under the stock symbol TDC.
The Teradata product is referred to as a "data warehouse system" and stores and manages data. The data warehouses use a "shared nothing" architecture, which means that each server node has its own memory and processing power.

MSBI

MSBI stands for Microsoft Business Intelligence. This powerful suite is composed of tools which helps in providing best solutions for Business Intelligence and Data Mining Queries. This tool uses Visual studio along with SQL server. It empower users to gain access to accurate and up-to-date information for better decision making in an organization. It offers different tools for different processes which are required in Business Intelligence (BI) solutions.

MSBI is divided into 3 categories

SSIS – SQL Server Integration Services – Integration tool.
SSAS – SQL Server Analytical Services -Analysis tool.
SSRS – SQL Server Reporting Services – Reporting tool.

After storing daily data of the customers who visited Calvin Klein outlet at different stores, the data is then integrated and saved it in a centralized database. This is done with the help of OLTP component of MS SQL Server. Integration means merging of data from different data stores (i.e. it may be a flat file, Excel sheets, Sybase, Oracle, etc.), refreshing data in data warehouses and to cleanse data (e.g. -Date format may be different for different outlet’s database, so same format is made to make it even) before loading to remove errors. Now, you must be clear with the Integration concept.

HADOOP Big Data

Hadoop

Hadoop runs applications using the MapReduce algorithm, where the data is processed in parallel on different CPU nodes. In short, Hadoop framework is capabale enough to develop applications capable of running on clusters of computers and they could perform complete statistical analysis for a huge amounts of data.

Hadoop Architecture:

Hadoop Common
Hadoop YARN
Hadoop Distributed File System
Hadoop MapReduce

Big Data

Big data usually includes data sets with sizes beyond the ability of commonly used software tools to capture, curate, manage, and process data within a tolerable elapsed time. Big data "size" is a constantly moving target, as of 2012 ranging from a few dozen terabytes to many petabytes of data. Big data is a set of techniques and technologies that require new forms of integration to uncover large hidden values from large datasets that are diverse, complex, and of a massive scale.

SAS

SAS (Statistical Analysis System) is a software suite developed by SAS Institute for advanced analytics, multivariate analyses, business intelligence, data management, and predictive analytics. SAS was developed at North Carolina State University from 1966 until 1976, when SAS Institute was incorporated. SAS was further developed in the 1980s and 1990s with the addition of new statistical procedures, additional components and the introduction of JMP. A point-and-click interface was added in version 9 in 2004. A social media analytics product was added in 2010.

The SAS software suite has more than 200 components Some of the SAS components include:

Base SAS – Basic procedures and data management
SAS/STAT – Statistical analysis
SAS/GRAPH – Graphics and presentation
SAS/OR – Operations research
SAS/ETS – Econometrics and Time Series Analysis
SAS/IML – Interactive matrix language
SAS/AF – Applications facility
SAS/QC – Quality control
SAS/INSIGHT – Data mining
SAS/PH – Clinical trial analysis
Enterprise Miner – data mining

Data Stage

DataStage is a central filestore with three added benefits
Security controls that allow researchers to have a "private" area only accessible to themselves and the group leader, and "shared" and "collaborative" areas to put files of use to the whole research group. Web interface allowing users to annotate their files, and access data from outside their "home" computer. The option to send data to a repository for permanent storage.

DataStage has three "areas" for files

Private: files are only visible to their owner, and the administrator.
Shared: files are visible to all group members, with read-only access.
Collaborative: files are visible to all group members, with read- and write-access.

Users can connect to DataStage as a mapped drive (analagous to the C:\ drive on their local computer, but held on an external storage system accessible to all group members). They can also upload, download, and annotate files using the web interface.

Cognos

Cognos (Cognos Incorporated) was an Ottawa, Ontario-based company making business intelligence (BI) and performance management (PM) software. Founded in 1969, at its peak Cognos employed almost 3,500 people and served more than 23,000 customers in over 135 countries until being acquired by IBM on January 31, 2008. While no longer an independent company, the Cognos name continues to be applied to IBM's line of business intelligence and performance management products.

Cognos grew successful with its business intelligence products for local area networks (LAN), but new Internet technologies had come into the BI industry faster than the company had anticipated. After Cognos issued a notice informing shareholders of a slowdown in growth, many sold their shares, causing prices to fall quickly.

This prompted Cognos to build its web technology through the acquisition of other companies rather than internal research and development.

Obiee

Oracle Business Intelligence Enterprise Edition Plus, also termed OBI EE Plus, is Oracle Corporation's set of business intelligence tools consisting of former Siebel Systems business intelligence and Hyperion Solutions business intelligence offerings.

The industry counterpart and main competitors of OBIEE are Microsoft BI, IBM Cognos, SAP AG Business Objects and SAS Institute Inc. The products currently leverage a common BI Server providing integration among the tools.

International Business Machines Corporation (commonly referred to as IBM) is an American multinational technology and consulting corporation, with headquarters in Armonk, New York. IBM manufactures and markets computer hardware, middleware and software, and offers infrastructure, hosting and consulting services in areas ranging from mainframe computers to nanotechnology.

SAP SE (Systems, Applications & Products in Data Processing) is a German multinational software corporation that makes enterprise software to manage business operations and customer relations.

Abinitio

Ab Initio Software is an American multinational enterprise software corporation based in Lexington, Massachusetts.The company specializes in high-volume data processing applications and enterprise application integration. It was founded in 1995 by the former CEO of Thinking Machines Corporation, Sheryl Handler, and several other former employees after the bankruptcy of that company. The Ab Initio products are provided on a user friendly platform for data processing applications. These applications perform functions relating to fourth generation data analysis, batch processing, data manipulation graphical user interface (GUI)-based parallel processing software which is commonly used to extract, transform, and load (ETL) data.

Ab Initio products include the following

Graphical Development Environment (GDE)
Cooperating System
Enterprise MetaEnvironment (EME)
ConductIt
the Component Library
Data Profiler
Business Rules Environment (BRE)

Ab Initio introduced a free feature-limited version known as Elementum in 2010. However, it is only available to customers who have already purchased commercial license for Ab Initio. This version is only intended for desktop use.

Web Sphere

WebSphere is an IBM brand of products that implement and extend Sun's JavaTwoEnterpriseEdition (J2EE) platform. The Java-based application and transaction infrastructure delivers high-volume transaction processing for e-business and provides enhanced capabilities for transaction management, as well as security, performance, availability, connectivity, and scalability.

In addition to Java, WebSphere supports open standard interfaces such as the Common Object Request Broker Architecture (CORBA) and Java Database Connectivity (JDBC) and is designed for use across different operating system platforms. One edition of WebSphere is offered for small-to-medium size businesses and another edition for larger businesses with a higher number of transactions.

WebSphere also includes Studio, a developer's environment with additional components that allow a Web site's pages to be created and managed. Both editions support Solaris, Windows NT, OS/2, OS/390, and AIX operating systems.

SOA / OSB

A service-oriented architecture (SOA) is an architectural pattern in computer software design in which application components provide services to other components via a communications protocol, typically over a network. The principles of service-orientation are independent of any vendor, product or technology.

A service is a self-contained unit of functionality, such as retrieving an online bank statement. By that definition, a service is a discretely invokable operation. However, in the Web Services Definition Language (WSDL), a service is an interface definition that may list several discrete services/operations. And elsewhere, the term service is used for a component that is encapsulated behind an interface. This widespread ambiguity is reflected in what follows.

Services can be combined to provide the functionality of a large software application. SOA makes it easier for software components on computers connected over a network to cooperate. Every computer can run any number of services, and each service is built in a way that ensures that the service can exchange information with any other service in the network without human interaction and without the need to make changes to the underlying program itself.

Tableau with R Language

R is a popular statistical language used to perform sophisticated statistical analysis and predictive analytics, such as linear and nonlinear modeling, statistical tests, time-series analysis, classification, clustering, etc.

The R-console primarily utilizes a command-line interface, but there are many GUI tools available for download to make it easier to write R programs (most of them are free). With R, users can create variables, formulas, functions, and graphs to visualize their analysis and predictions.

R functions and models can now be used in Tableau by creating new calculated fields that dynamically invoke the R engine and pass values to R. The results are then returned back to Tableau for use by the Tableau visualization engine.

This feature is primarily targeted for users who are already proficient at R. It is NOT meant for beginners with R. Anyone who wishes to use the new functions must first learn how to use R in order to leverage its capabilities in Tableau.

Quick View

QuickView is a file viewer in Windows 95, Windows 98 and Windows NT 4.0 operating systems. The viewer can be used to view practically any file.The software has been ported by third parties to support XP, Vista and 7.

On 1995-04-03, InfoSoft International, Inc., announced the acquisition of Systems Compatibility Corporation,and the renaming of InfoSoft International, Inc. to Inso Corporation. Inso Corporation later developed Quick View Plus products.

Quick View Plus is a commercial variant based on Inso Corporation (later IntraNet Solutions, Inc., Stellent Inc., Oracle)'s Outside In technology.The Windows 3.1 version of the product was originally named Outside In for Windows 3.1 before it was renamed to Quick View Plus for Windows 3.1. The Outside In name was reused as the viewer engine for Quick View Plus products.The distributor was later changed to Avantstar, Inc., founded by Stellent's close associates in 2001.

WORKSHOPS