Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3 Answers
- 7148 Views
- I also Faced
- E-Mail Answers
Answer Posted / krish
decode(sal,65020,Sixty five thousand twenty)
decode(sal,78250,Seventy thousand two fify)
decode(sal,58264,Fifty eight thousand two sixty four)
| Is This Answer Correct ? | 3 Yes | 10 No |
Post New Answer View All Answers
What is a passive transformation?
Why update strategy and union transformations are active?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
can anyone explain me about retail domain project in informatica?
Explain the difference between a data warehouse and a data mart?
What is a sorter transformation?
How can you generate reports in informatica?
What are connected or unconnected transformations?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
How can you validate all mappings in the repository simultaneously?
Write the advantages of partitioning a session?
How does the aggregator transformation handle null values?
What is expression transformation?
What is rank transformation?
