How to generate a star pattern using Informatica?

How to generate a star pattern using Informatica depending on the number of rows in the input file
Suppose there are 7 rows in the source file (any type of data), the target should have 7 rows of stars in the following pattern:-
*
***
*****
*******
*********
***********
*************

Showing Answers 1 - 3 of 3 Answers

SUM

  • Oct 8th, 2015
 

v_star=iif( v_vount < = 1,*,rpad(v_star,vcount,*))
v_count=v_count+2
O_STAR=V_STAR

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions