Answer Posted / rahul singh

We can use a simple function (TO_CHAR(TO_DATE(1234567,'J'),
'JSP')) this will return you ONE MILLION TWO HUNDRED
THIRTY-FOUR THOUSAND FIVE HUNDRED SIXTY-SEVEN . But this has
limitation to be used only for numbers between 1 and 5373484
.For numbers larger than that use following function and
call it in informatica through external function
transformation .

create or replace
2 function spell_number( p_number in number )
3 return varchar2
4 as
5 type myArray is table of varchar2(255);
6 l_str myArray := myArray( '',
7 ' thousand ', ' million ',
8 ' billion ', ' trillion ',
9 ' quadrillion ', '
quintillion ',
10 ' sextillion ', ' septillion ',
11 ' octillion ', ' nonillion ',
12 ' decillion ', ' undecillion ',
13 ' duodecillion ' );
14
15 l_num varchar2(50) default trunc( p_number );
16 l_return varchar2(4000);
17 begin
18 for i in 1 .. l_str.count
19 loop
20 exit when l_num is null;
21
22 if ( substr(l_num, length(l_num)-2, 3) <> 0 )
23 then
24 l_return := to_char(
25 to_date(
26 substr(l_num,
length(l_num)-2, 3),
27 'J' ),
28 'Jsp' ) || l_str(i) || l_return;
29 end if;
30 l_num := substr( l_num, 1, length(l_num)-3 );
31 end loop;
32
33 return l_return;
34 end;

How to join three sources using joiner? Explain though mapping flow.

1189

---

What is Session and Batches?

1147

---

What is meant by query override?

1112

---

What are the guidelines to be followed while using union transformation?

1206

---

What are the popular informatica products?

1056

---

What does cheating measurement mean?

1105

---

Is there any target staging area in informatica not staging area

2631

---

What is meant by lookup transformation?

1180

---

What are the advantages of informatica?

1057

---

What is joiner transformation in informatica?

1098

---

In informatica workflow manager, how many repositories can be created?

1435

---

How to handle decimal places while importing a flatfile into informatica?

1240

---

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7234

---

How do you convert single row from source into three rows into target?

1210

---

What is a sorter transformation?

1155

---