Answer Posted / ravindran
Select upper('tamilnadu') from dual; There is no toupper
function in Oracle
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
Explain the definition of normalized and denormalized view and what are the differences between them?
Explain the difference between filter and conditin?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.
Why is dimensional normalization not required?
How can we do data cleaning?
Can a dimension table contain numeric values?
Explain what is fact less fact table? Where you have used it in your project?
What is a real-time data warehouse? How is it different from near to real-time data warehouse?
Explain what are the methodologies of data warehousing?
Can you pass sql queries in filter transformation?
Difference between cold fusion mx 6 and cold fusion mx 7?
How can you clear the cache?
What is the difference between filter and lookup transformation?
What are the steps involved in designing a fact table?
i have scheduled a report in a job in the cognos8.3 which would send the reports to the respective user ,now the repot ran and is sent to the respective user but it contains some unwanted data. So based on the senario can any one tell me that can we recall back the report ??????