How to Convert Julian date to Gregorian 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 calendar for further informatica processing. We can use TO_DATE function to convert the Julian date to Gregorian in an expression and then… Continue reading How to Convert Julian to Gregorian date in Informatica
Tag: Expression
How to remove duplicate records using Expression
How to remove duplicate records using Expression In the last post we have used Aggregator Transformation to remove the duplicate records. In this post we will use the Expression transformation to remove the duplicate JOB_ID from the source Flat file. Source – Flat File Target – Oracle Table Key port – JOB_ID Transformations Sorter – To… Continue reading How to remove duplicate records using Expression
How to concatenate the first and last name – Expression Transformation
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 & Last name and storing to a new column in target as Full Name using CONCAT function in… Continue reading How to concatenate the first and last name – Expression Transformation