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
- 7205 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
Explain the informatica workflow?
What are the different clients of powercenter?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
In development project what is the process to follow for an etl developer from day1
COM components can be used in Informatica
What is substr in informatica?
Can informatica load heterogeneous targets from heterogeneous sources?
What is Index Caches size?
On which transformations you created partitions in your project?
In which transformation you cannot drag ports into it?
What is joiner change?
What are data-driven sessions?
Differentiate between router and filter transformation?
hi real timers . iam waiting for ur reply regarding ETL TESTING
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
