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
7209 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

Explain pmcmd command usage in informatica

1140

Define pmcmd command?

1049

What do you mean incremental aggregation?

1085

What are pre and post-session shell commands?

1321

Different qualification between a related rotate toward the sky and isolates look upward?

993

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1288

Can we create multiple integration service on single repository?

1197

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1802

What all join we can perform in LOOKUP transformation?

986

Why union transformation is an active transformation?

1050

What you know about transaction control transformation?

997

What is the difference between informatica 7.0 and 8.0?

1019

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2325

Define the various join types of joiner transformation?

990

How many number of sessions can one group in batches?

1163