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
- 7339 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 a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
How to load the data from people soft hrm to people soft erm using informatica?
How do you convert single row from source into three rows into target?
What is different between the data warehouse and data mart?
What is the need of an ETL tool?
How to delete duplicate row using informatica?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Define Pmrep command?
How do you remove duplicate records in informatica? And how many ways are there to do it?
Explain sessions. Explain how batches are used to combine executions?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
