0

i need to use similar function like WM_CONCAT (in oracle) to be used in SQL worksheet(Informatica)

e.g

<COlumm>
------
val1
val2
val3
val4

after concat :output shud be

<Column>
-------
val1,val2,val3,val4

that is String concat.

jarlh
  • 42,561
  • 8
  • 45
  • 63
backToStack
  • 101
  • 6
  • `STRING_AGG()` is what you're looking for – Ilyes Apr 20 '20 at 08:49
  • 1
    This questions should not be closed. This is Informatica related and not a SQL server question unless OP thinks he can do this in SQL server. Now in informatica, you can do this- Mapping should be like this SRC-->SQ-->SRT-->EXP-->AGG-->TGT. SRT on key_column. in exp, create 5 ports - key_col val v_val= iif(key_col !=v_key_col,val,v_val||' '||val) v_key_col = key_col o_val=v_val -- in the agg, pick max( o_val) group by key_col – Koushik Roy Apr 20 '20 at 10:06
  • its for Informatica Data Vault SQL Worksheet related syntax that i am searching for to achieve the requriement – backToStack Apr 20 '20 at 20:51
  • hmm, pls try above solution and let me know if its fine. – Koushik Roy Apr 22 '20 at 13:05
  • m nt sure how to apply it, the pblm is i have a query which displays 5 columns, out of that the 5th column value is comming from a sub query... now since subquery should return only 1 row, we used wm_concat function is oracle that concatenates all the values and shows in 1 row. this i want to do kn sql worksheet.... bt wm_concat aggregate function is not available. – backToStack Apr 23 '20 at 15:35

0 Answers0