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
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 pipeline partition with real time example?
what are factless facts? And in which scenario will you use such kinds of fact tables.
Can we create a Integration service without a Repository service and vice versa?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What is a pre-defined event and user-defined event?
How can you increase the performance in joiner transformation?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
write a query to retrieve the latest records from the table sorted by version(scd)
whats the logic to load the lower level of granularity of data to fact table.
Why update strategy and union transformations are active? Explain with examples.
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Enlist some properties of sessions.
how to load dimension table and fact table. plz tell me the steps.
Explain where to store informatica rejected data? How to extract the informatica rejected data?