Knowledge Base

How to Setup Informatica Client Tool in your system

How to Create Connections from Oracle and Flat File to IICS

Filter Transformation in IICS

Expression Transformation in IICS

Sorter Transformation

Joiner Transformation

Connection to the SSIS Server

Process to Connect VPN & Remote Desktop

Load data from OLEDB source table to OLEDB destination in a table

How to perform Date type conversion in SSIS (Data Conversion)

Derived Column Transformation

AGGREGATE TRANSFORMATION IN SSIS

SQL COMMANDS

Sql Select Distinct Statement

Sql Operators

SQL UPDATE/DELETE Statement

Sql Joins

LIKE, BETWEEN AND ALIAS