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
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
my source is junk data how will u remove that junk data by using unix please any one replay me
Explain the types of transformations?
What is a code page?
How are the sources and targets definitions imported in informatica designer?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What is aggregate cache in aggregator transformation?
What do you mean by blocking transformation?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Suppose we do not group by on any ports of the aggregator what will be the output?
what is Active lock explain
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What is workflow? What are the components of workflow manager?
Explain the different kinds of facts.
How to join three sources using joiner?
Which transformation should we use to normalise the COBOL and relational sources?