Auto generate sequence numbers in Target tables using Oracle sequence
Kareem
Thursday, January 03, 2019
· Create a Target table with below structure by adding sequence column CREATE TABLE "TARGET"."EMP_SEQ&quo...
Thursday, January 3, 2019
Why Sorter is an Active transformation ?
Kareem
Thursday, January 03, 2019
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
Kareem
Wednesday, August 29, 2018
Informatica Software Architecture illustrated as : Informatica ETL product, known as Informatica Power Center consists of 3 main componen...
Convert Julian date in Informatica
Kareem
Wednesday, August 29, 2018
Dates in the Julian calendar are called Julian dates which are not supported in Informatica. We need to convert the date to Gregorian cal...
Wednesday, July 18, 2018
Save Informatica session logs with Timestamp
Kareem
Wednesday, July 18, 2018
Save Informatica session logs with Timestamp Informatica PowerCenter gives an option to save the session logs with Timestamp. Be...
Tuesday, July 3, 2018
How To Generate Dynamic Target File In Informatica Based On Column Value
Kareem
Tuesday, July 03, 2018
Generate different flat file target based on the Location name, like separate files for Mumbai.dat, Bangalore.dat, and Delhi.dat Sourc...
Monday, July 2, 2018
Informaica Power Center v10 - Features
Kareem
Monday, July 02, 2018
Introduction : Informatica – the world’s leader in ETL market and number one independent software provider officially released Info...
Powermart PMREP Commands
Kareem
Monday, July 02, 2018
The entire in this section describe changes to pmrep. Command Description Comments AssignPermission Assigns permissions on ...
