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
- 6306 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
How to convert multiple rows to single row (multiple columns) in informatica
What are the various types of transformation?
How to elaborate powercenter integration service?
Define filter transformation?
What is the difference between informatics 7x and 8x and what is latest version?
What are session parameters ? How do you set them?
how tokens will generate?
What is data movement mode in Informatica and difference between them?
Explain the pipeline partition with real time example?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
can any one give some examples for pre sql and post sql(Except dropping and creating index).
what is size of u r database?
What are the types of caches in lookup?
How to extract sap data using informatica? What is abap? What are idocs?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
