4 Replies Latest reply on Mar 4, 2021 11:56 AM by Nico Heinze

    How to achieve - count(input_col1) over(partition by input_col2,input_col3)

    inuser526279 Guru

      Hi Team,

       

      I'm trying to achieve below requirement in Informatica powercenter?

       

      select t.*, count(t.input_col1) over(partition by t.input_col2,t.input_col3) as cnt from table 1;

       

      Really appreciate your help.