Thursday, January 3, 2019

Auto generate sequence numbers in Target tables using Oracle sequence

›
·          Create a Target table with below structure by adding sequence column      CREATE TABLE "TARGET"."EMP_SEQ...
5 comments:

Why Sorter is an Active transformation ?

›
The Sorter transformation is almost always changes the order of records - by delivering the records sorted by the sort keys.  There ...
Wednesday, August 29, 2018

Informatica PowerCenter Architecture

›
Informatica Software Architecture illustrated as : Informatica ETL product, known as Informatica Power Center consists of 3 main componen...
2 comments:

Convert Julian date in Informatica

›
Dates in the Julian calendar are called Julian dates which are not supported in Informatica. We need to convert the date to Gregorian cal...
2 comments:
Wednesday, July 18, 2018

Save Informatica session logs with Timestamp

›
Save Informatica session logs with Timestamp Informatica PowerCenter gives an option to save the session logs with Timestamp.  Be...
1 comment:
Tuesday, July 3, 2018

How To Generate Dynamic Target File In Informatica Based On Column Value

›
Generate different flat file target based on the Location name, like separate files for Mumbai.dat, Bangalore.dat, and Delhi.dat Sourc...
1 comment:
Monday, July 2, 2018

Informaica Power Center v10 - Features

›
Introduction : Informatica – the world’s leader in ETL market and number one independent software provider officially released Info...
1 comment:

Powermart PMREP Commands

›
The entire in this section describe changes to pmrep. Command Description Comments AssignPermission Assigns permissions on ...