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
- 7055 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
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
Explain about Informatica server process that how it works relates to mapping variables?
How would you join a node to the already existing domain?
What is incremental aggregation?
What is an expression transformation in informatica?
What are the transformations that are not supported in mapplet?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What is flashback table ? Advance thanks
What is the scenario which compels informatica server to reject files?
How would you copy the content of one repository to another repository?
How to create or import flat file definition in to the warehouse designer?
how to load dimension table and fact table. plz tell me the steps.
difference between informatica 8.1.1 and 8.6
What is the different lookup cache(s)?
Briefly define reusable transformation?
