Basic Informatica Tutorial

Hive organizes the tables into partitions, and partitions are subdivided into buckets. ALTER TABLE table_name ADD [IF NOT EXISTS] PARTITION ...

CREATE DATABASE [IF NOT EXISTS] userdb; DROP DATABASE IF EXISTS userdb; IF NOT EXISTS : This is a optional clause we are using to remove the...

Data types in Hadoop are classified into 4 types - Column Types - Literals - Null Values - Complex Types When the data range exceeds the ran...

The term bigdata is used to refer large volumes of data. Using the traditional way to handle this data is very difficult. So, the Apache sof...

Window functions perform calculations across a set of rows related to the current row without collapsing the rows into a single result. Unli...

ICS provides a list of tasks like linear taskflow, taskflow, parallel tasks, parallel tasks with decision, sequential tasks, sequential task...

IICS provides a list of tasks like mapping task, powercenter tasks, synchronization task, replication task, masking task, dynamic mapping ta...