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;

Explain the pipeline partition with real time example?

1082

---

what is diff b/t sorter t/r and agg have the option sorter property...

2128

---

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2676

---

What do you mean by worklet?

1017

---

Explain lookup transformation source types in informatica

1039

---

Explain what is informatica metadata and where is it stored?

986

---

Explain transaction control transformation in informatica

1210

---

How can informatica be used for an organization?

1128

---

How can we delete duplicate rows from flat files?

1161

---

What is informatica? Why do we need it?

1038

---

What is depict expression change?

1025

---

Differentiate between a database and data warehouse?

1088

---

Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

1973

---

Explain the difference between a data warehouse and a data mart?

999

---

What is meant by incremental aggregation?

1020

---