if its in oracle database,use select id, name, (SELECT TO_CHAR (TO

i have source data like

id name sal
1 a 65020
2 b 78250
3 c 58264

but how to get target like this

id name sal
1 a Sixty five thousand twenty
2 b Seventy thousand two fify
3 c Fifty eight thousand two sixty four

Question Posted / chiky

3 Answers
7049 Views
I also Faced
E-Mail Answers

Answer Posted / chiky

if its in oracle database,use

select id, name, (SELECT TO_CHAR (TO_DATE sal, 'j'), 'jsp')
FROM DUAL) sal from <source_table_name>

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1928

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

2065

What is the maplet?

1041

Define joiner transformation?

990

What is a connected transformation?

1051

How would you copy the content of one repository to another repository?

952

How to do the error handling of if ur source is flatfiles?

1913

Explain lookup transformation is active in informatica

1038

Explain direct and indirect flat file loading (source file type) - informatica

1264

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.

2681

I have a flat file, want to reverse the contents of the flat file

1068

Scheduling properties,whats the default (sequential)

1896

Explain constraint based loading in informatica

1041

What is deployment group?

1132

What will be the approach?

930