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
- 7156 Views
- I also Faced
- E-Mail Answers
Answer Posted / chiky
if its in oracle database,use
select id, name, (SELECT TO_CHAR (TO_DATE sal, 'j'), 'jsp')
FROM DUAL) sal from <source_table_name>
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
How many numbers of sessions can one group in batches?
Briefly explain the aggregator transformation?
What is substr in informatica?
what is INFORMATICA TESTING process
What is a stored procedure transformation?
What does command task mean?
What is pmcmd command?
can we override a native sql query within informatica? Where do we do it? How do we do it?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What is session task and command task?
what is the hint? how to use it to reduce the query processing in program?
What is lookup transformation?
How we can create indexes after completing the load process?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
