write a sql query following source?
subject mark
maths 30
science 20
social 80
requird output
maths science social
30 20 80
- 3 Answers
- 6063 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / brij
select
decode(subject,'maths',mark) maths
,decode(subject,'science',mark) science
,decode(subject,'social',mark) social
from <<table>>
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
What is a snowflake schema?
Explain lookup transformation in informatica
What are the tasks that source qualifier perform?
How to elaborate tracing level?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
Does an informatica transformation support only aggregate expressions?
How to handle decimal places while importing a flatfile into informatica?
What are the different types of transformation available in informatica.
How do you load unique records into one target table and duplicate records into a different target table?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Have you worked with/created Parameter file
Which files are created during the session rums by informatics server?
In warehouses how many schemas are there?
What is lookup change?
What is deployment group?
