Author: kvt

How to create connections in Oracle SQL developer

No Picture

Create User & connections in Oracle SQL developer You should create at least one database user that you will use to create database objects. Here i created a database connection (ORACLEXE) for the SYSTEM user. Now I am…

Read More »

Informatica – Working with Delimited Flat Files

No Picture

Informatica – Working with Tab Delimited Flat Files Source : Tab delimited Flat file Target  : Oracle Table Create a target table, here its a oracle table with same layout as source file Start the job and review…

Read More »

Informatica – Working with Fixed Width Flat Files

No Picture

Informatica – Importing Fixed Width Flat Files — Fixed-width flat files are byte-oriented (measured in bytes). — It can also be line sequential, which means each row ends with a newline character. — Use Flat File Wizard to…

Read More »

TM_6281 ERROR: Partitioning option license required to run sessions with user defined partition points

No Picture

TM_6281 ERROR: Partitioning option license required to run sessions with user defined partition points. Your session may fail with this error while doing aggregator transformation with ‘Sorted Input’ enabled. This is not a data Issue but a configuration…

Read More »

How to concatenate the first and last name – Expression Transformation

No Picture

Informatica – How to concatenate the first and last name – Expression Transformation Using expression transformation we can combine two strings to a single string and load to target. Here we are going to concatenate First Name &…

Read More »

PCSF_46008 Cannot connect to domain to lookup service

No Picture

Informatica – PCSF_46008 Cannot connect to domain to lookup service You may experience this error while trying to connect to PowerCenter developer tools like Repository Manager, Designer, workflow Manager or workflow monitor. This error might be due to…

Read More »

PowerCenter Express Overview

No Picture

PowerCenter Express Overview — Its a single unified enterprise data integration platform. — Use PowerCenter Express to design and implement data integration solutions. — Use it to extract data from multiple sources, transform the data according to business logic, and…

Read More »

Informatica Transformations – Types

No Picture

Types of Transformations  A transformation is a repository object that generates, modifies, or passes data. The Designer provides a set of transformations that perform specific functions. For example, an Aggregator transformation performs calculations on groups of data. Transformations in…

Read More »

Informatica Transformations – Overview

No Picture

Transformation Overview A transformation is a repository object that generates, modifies, or passes data. The Designer provides a set of transformations that perform specific functions. Transformations in a mapping represent the operations the Integration Service performs on the…

Read More »

How to unlock HR sample account in oracle 11G express edition

No Picture

How to Unlock HR sample account in oracle 11G express edition This session will cover how to unlock HR sample account in oracle 11G express edition. Here is the steps to follow … 1. Go to CMD (Command Prompt)…

Read More »

Informatica Troubleshoot

No Picture
Read More »

Informatica Transformations

No Picture
Read More »

Realtime informatica scenarios

No Picture
Read More »

Install Informatica 9.6.1

No Picture
Read More »