background preloader


Facebook Twitter

ian bishop

Cassandra Interview Questions and Answers. 1). What is Apache Cassandra? Apache Cassandra is an open source data storage system developed at Facebook for inbox search and designed for storing and managing large amounts of data across commodity servers. It can server as both – Real time data store system for online applications – Also as a read intensive database for business intelligence system Apache Cassandra is an open source, distributed and decentralized/distributed storage system (database), for managing very large amounts of structured data spread out across the world. 2). The design goal of Cassandra is to handle big data workloads across multiple nodes without any single point of failure. 3). NoSQL database (sometimes called as Not Only SQL) is a database that provides a mechanism to store and retrieve data other than the tabular relations used in relational databases. 4).

Java 5) . – Document Stores (MongoDB, Couchbase) – Key-Value Stores (Redis, Volgemort) – Column Stores (Cassandra) – Graph Stores (Neo4j, Graph) 6). Type. 7). Processing Flat Files in Informatica. How to Hide, Delete and Show WorkSheets in Tableau. Show & Hide WorkSheets in Tableau A worksheet that is used in a dashboard cannot be deleted, but it can be hidden. You may want to hide a worksheet if you are sharing the dashboard with others and don’t want to clutter the workbook with all the supporting worksheets. You can hide the worksheets that are used in a dashboard by right-clicking the worksheet tab and selecting Hide Sheet. Keep in mind that someone viewing the dashboard can still access the hidden worksheet. You can show a hidden sheet by navigating to the dashboard that uses it. Select Go to Sheet on the dashboard view menu.

Deleting WorkSheets in Tableau Deleting a sheet removes it from the workbook You can delete the active sheet by right-clicking the worksheet or dashboard tab along the bottom of the workbook and selecting Delete Sheet. Adobe CQ5 AEM Interview Questions & Answers. What is AEM? Adobe Experience Manager (AEM), is a java based content management system that is offered from Adobe. It was previously called Day CQ5, but was acquired from Adobe in 2010. AEM is based on a content repository and uses the JCR to access the content in the repository. AEM uses the Apache Sling framework to map request url to the corresponding node in the content repository.

It also uses the OSGI framework to internally allow modular application development. What are the advantages of AEM over another CMS? One big advantage of AEM over another CMS is how it integrates with other products from Adobe and with the Adobe Marketing Cloud. What is the technology stack that CQ5 is based on?

The CQ5 technology stack is based on three technologies. What is the role of the dispatcher? The dispatcher is AEM’s caching and/or load balancing tool. What is sightly? Sightly is an HTML templating language that was introduced in AEM 6.0. Why is a Content Management System (CMS) required? JENKINS Interview Questions and Answers. Mention Jenkins? Jenkins is an open source tool with plugin built for continuous integration purpose. The principle functionality of Jenkins is to keep a track of version control system and to initiate and monitor a build system if changes occur.

It monitors the whole process and provides reports and notifications to alert. Explain what is continuous integration? In software development, when multiple developers or teams are working on different segments of same web application, we need to perform integration test by integrating all modules. In order to do that an automated process for each piece of code is performed on daily bases so that all your code get tested.

What is the requirement for using Jenkins? To use Jenkins you require – A source code repository which is accessible, for instance, a Git repository – A working build script, e.g., a Maven script, checked into the repository Mention what are the advantages of Jenkins? Advantage of Jenkins include – Maven 2 project – Amazon EC2 – Join. Mule ESB Interview Questions. What is Mule ? Mule ESB (a.k.a. Mule) is a lightweight Java-based enterprise service bus (ESB) and integration platform that allows developers to connect applications together quickly and easily, enabling them to exchange data. Mule ESB enables easy integration of existing systems, regardless of the different technologies that the applications use, including JMS, Web Services, JDBC, HTTP, and more.

What is ESB? An enterprise service bus (ESB) is software architecture for middleware that provides fundamental services for more complex architectures. What are all the Primitives used in Mediation? We have different types of primitives in mediation. -Message Filter -Type Filter -Endpoint Lookup -Service Invoke -Fan-out -Fan-in -BO Map -Message Element Setter -DB lookup -Data Handler -Custom Mediation -Header Setters -Message Logger -Even Emitter -Stop -Fail -Sub Flow What is Shared Context?

What is Transient Context? What is Correlation Context? Used to pass values from the request message onto the response. XML Source Qualifier Transformation in Informatica. XML Transformation in Informatica The XML Parser transformation lets you extract XML data from messaging systems, such as TIBCO or MQ Series, and from other sources, such as files or databases. The XML Parser transformation functionality is similar to the XML source functionality in Informatica,except it parses the XML in the pipeline. Types of XML Transformations XML Source Qualifier Transformation XML Parser Transformation To get Informatica Live Training, please visit: Source Qualifier Transformation in Informatica It is an active transformation, as well as connected transformation.

XML Source Qualifier has one input or output port for every column in the source. The XML Parser transformation reads XML data from a single input port and writes data to one or more output ports.XML Generator Transformation Overview: It’s an also active transformation, as well as connected. To read about other Informatica Transformation Tutorials, please click here.

Free COGNOS Study Guide | Self Learning COGNOS Online. Inspecting Data in Tableau. Once you have created a view, Tableau offers a selection of dynamic data inspection tools that help you isolate the data of interest and then continue to explore and analyze. For example, if you have a dense data view, you can focus on a particular region, select a group of outliers, view the underlying data source rows for each mark, and then view a summary of the selected marks include the average, minimum, and maximum values. Select Zoom Controls Pan Undo and Redo Drop Lines Summary Card View Data Describing the View Selecting marks is useful when you want to visually identify a subset of the data view or you want to run an action. You can select any individual mark by clicking on it. Tableau has a set of zoom controls that display in the upper left corner of the view. Automatic– displays when you hover the mouse over map views.Hide– never displays.Show on hover – displays when you hover the moust over all views.

Zoom In and Out Area Zoom Reset Axes To add drop lines to the view: Note: Normalizer Transformation in Informatica with Examples. Normalizer Transformation This post is continuation of Informatica Tutorials. Normalizer transformation type is Active & Connected. The Normalizer transformation is used in place of Source Qualifier transformations when you wish to read the data from the cobol copybook source.

Also, a Normalizer transformation is used to convert column-wise data to row-wise data. This is type an active from transaction which allows you to read the data from cobal files. Use the normalize transformation to convert a single input record into multiple output records, this is known as horizontal port Normalizer Transformation Uses Normalizer can be used to deal with multiple-occurring columns andmultiple record types created using redefines. Normalizer Transformation Properties Active /Passive : Normalizer Transformation is a Active transformation as it create multiple row for each input row.

Connected/Unconnected Transformation : Normalizer Transformation is a connected Transformation. Port Details Account.txt Ex: Want To Build A New Career In Teradata | Teradata Tutorials. Welcome to Teradata Tutorials. The intent of these tutorials is to provide in depth understanding of Teradata Database. In addition to Teradata Tutorials, we will look at common interview questions, how to tutorials, issues and their resolutions Teradata database now able to connect Hadoop with this QueryGrid so it’s called as Teradata Database-to-Hadoop also referred as Teradata-to-Hadoop connector. It provides a SQL interface for transferring data between Teradata Database and remote Hadoop hosts.

-Import Hadoop data into a temporary or permanent Teradata table. -Export data from temporary or permanent Teradata tables into existing Hadoop tables. -Create or drop tables in Hadoop from Teradata Database. -Reference tables on the remote hosts in SELECT and INSERT statements. -Select Hadoop data for use with a business tool. -Select and join Hadoop data with data from independent data warehouses for analytical use. Teradata Objects Teradata SQL data manipulation statements (non-procedural) Note Sam. Expression Transformation in Informatica with Examples. Expression transformations are used for row-wise manipulation. For any type of manipulation you wish to perform on an individual record, use an Expression transformation.

The Expression transformation accepts the row-wise data, manipulates it, and passes it to the target. The transformation receives the data from the input port and sends the data out from output ports. This is of type passive transformation which allows you to calculate the expressions for each record. An expression transformation in Informatica supports to write expression either in variable ports or only in output ports. Informatica Expression Transformation Uses Use an Expression Transformation to derive the new attributes to change the inconsistent data into consistent format. Use Expression Transformations for any row-wise calculation, such as if you want to concatenate the names, get the total salary, and convert it to uppercase An expression transformation is created with following types of ports. Variable Ports Read. Advantages and Disadvantages of C++ language. What is C++ ? C++ is an object oriented programming language What is language ?

A language is a software computer is an electronic device cannot perform operating by own. Language provide set of instructions to perform operations by computer. Language is nothing but programming tool C++ is the name of the language ‘c’ language is derived from ‘B’ language ‘B’ language is derived from BCPL ‘C’ language develops in the year 1972 C++ language is develops in the year 1980 What is a Program? Set of instructions or collection of instructions and data. Programming elements are i) Data ii) instruction In order to write a program to required Data and instructions. programming is nothing but process of organize data and instructions according to given problem object oriented means rules and regularity What are Programming Principles Programming principle define set of rules and regulations for organization of data and instructions Process Monolithic programming Process oriented programming Modular oriented programming.

Lookup Transformation in Informatica with Examples. Lookup Transformation The Lookup transformation is used to look up a source, source qualifier, or target to get the relevant data. You can look up flat file and relational tables. The Lookup transformation in Informatica works on similar lines as the joiner, with a few differences. For example, lookup does not require two sources. Lookup transformations can be connected and unconnected.

This is the type passive transformation which allows you to perform lookup on relational table. When the mapping contain the workup transformation the integration service queries the lock up data and compares it with lookup input port values. The lookup transformation is created with following type of ports Input port (I)Output port (O)Look up Ports (L)Return Port (R) The lookup transformation support horizontal merging such as equijoin and non equijoin. Informatica Lookup Transformation Uses Lookup transformation is used to return following tasks. – get a related value – in updating slowly changing dimension.