for example the table in my source system will have 3 columns month, name and job and I want to add another column through informatica cloud to give each row a number like shown below
S.No month name job 1 Jan 19 sean A 2 Jan 19 jean B 3 Jan 19 jane C
1 of 1 people found this helpful
Hope the query is clarified with above.
You can also cerate any expression variable for count and add it as a column however sequence generator will be the better way.