Toggle navigation
Log in
Sign Up
Log in
Sign Up
Appium
C
C#
C++
Docker
Go
Informatica
Java
JavaScript
Kafka
Numpy
Oracle
Pandas
PHP
Py Spark
Python
R
React Native
Scipy
SFTP
Tableau
Teradata
TGMC
UNIX
Introducing
Radical.sh
Forget Code launches a powerful code generator for building API's
Forget_Code.Models.CategoryViewModel
Add a new snippet
Conversion Functions
1
Date Functions
8
Encryption
1
Math Functions
2
Operators
1
String Functions
9
Choose Category
First - Returns first value of a port or group in Informatica
Forget Code
Informatica
First - Returns first value of a port or group
First is an aggregation function available in aggregator transformation, and it returns the first value of a port (depending upon ports grouped). If no ports are grouped, Infa considers all the rows as one group and returns first value.
Syntax
FIRST(port[,filter_condition])
FIRST(pen,cost_usd > 5)
If a value is NULL, it is ignored. While if all the values are null, First returns NULL as output.
pen
cost
pentel
6
Parker
10
ABC
NULL
Output : Pentel
Tags for First - Returns first value of a port or group in Informatica
first function in infa
first aggregator function
using first function in informatica
aggregator first informatica not working
informatica aggregator first row
informatica aggregator group by
informatica aggregator without group by
aggregator transformation first
FIRST() function in aggregator transformation
Contribute to Forget Code, help others.
Add snippet