Business Intelligence Processing Multi Schema Files in Talend By Nikhilesh Processing Multi schema files in Talend Some times, we will get the input files which contains the data about different schema format but in single file. We can process these files to get the data schema wise by using tFileinputMSDelimited....
Databases Backup and Restore MySQL DB Using mysqldump By Sayali Mahale mysqldump is a tool used to backup MySQL Database. It creates .sql file having DROP TABLE , CREATE TABLE , INSERT INTO TABLE sql Statements. To restore the database we have to execute the .sql file on destination database. Using...
Services Web Service at a Glance By Somen Sarkar Web Service at a Glance. What is Web Service? A Web service is medium of communication between two electronic devices over a network. It is platform independent and programming language independent. They help us to exchange information across different machines....
Front End How to Use System Commands in LUA By Nikhilesh How to use system commands in LUA Lets assume we have some requirement to call Unix-commands on the click of a button by using LUA . To achieve this follow these steps : 1. First check your Lua page is...
Java Java Policy File By Nikhilesh JAVA POLICY FILE The Java™ 2 Platform, Enterprise Edition (J2EE) Version 1.3 and later specifications have a well-defined programming model...
Java Finding all the Back-Edges in an Un-Directed Graph By Nikhilesh Finding all the backedges in an undirected graph Finding cycles in a graph is an interesting problem. We say that a cycle is formed if there is a way to reach the source without visiting already visited vertices. In this...
Front End Drag and Drop in React DND By Nikhilesh DRAG AND DROP IN REACT [caption id="attachment_5391" align="aligncenter" width="300"] React DND[/caption] This is an example of implementing drag and drop functionality using React. This is the first example where we’ll use an external library, in this case, React DnD. Components...
Business Intelligence Staging DB in Data Warehousing – The WHYs and WHY NOTs By Shraddha Tambe Staging DB in Datawarehousing - The WHYs and WHY NOTs Whenever we talk about designing datawarehouses, staging database is one consideration we have to make. And it depends on many factors whether you choose to have one or not. I...
ETL What is a lookup? How is it different from the Merge Join component in Pentaho ETL? By Nikhilesh What is a lookup? How is it different from the Merge Join component in ETL? Lookup: A lookup is basically accessing data from a relational tables which are not sources in the mapping table. In SQL Terms, a lookup is...
Business Intelligence Introduction to Mango Automation(M2M) By Sayali Mahale What is Mango Automation (m2m)? Machine to Machine (M2M) refers to data communications between machines. The term also means the complexity of sensors which produce data, the communications channel which connects the sensors to a server computer and a software...
Databases Lateral Subqueries in Postgres By Nikhilesh Lateral subqueries in Postgres Postgres has feature to use value from preceding table using keyword lateral. This is used for cross-referencing. means Subqueries appearing in FROM can be preceded by the key word LATERAL. This allows them to reference columns...
Software Testing Verification and Validation in Software Testing By K Ramakrishna Verification and Validation in Software testing Before getting into the various strategies of testing we must understand the process of verifying and validating the software code. Verification and validation is the generic name given to checking processes which ensure that the software conforms to its...