write a sql query following source?
subject mark
maths 30
science 20
social 80
requird output
maths science social
30 20 80
- 3 Answers
- 5829 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / srikanth
select (select marks from sub where subject='maths') maths,
(select marks from sub where subject='science') science,
(select marks from sub where subject='social') social from
sub group by 1;
| Is This Answer Correct ? | 15 Yes | 0 No |
Post New Answer View All Answers
State the limitations where we cannot use joiner in the mapping pipeline?
What is a surrogate key?
Why do you use Mapping Parameter and mapping variable?
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?
What is enterprise data warehousing?
Explain the informatica workflow?
I have a flat file, want to reverse the contents of the flat file
Explain why we use partitioning the session in informatica?
What are the uses of etl tools?
Explain about Informatica server process that how it works relates to mapping variables?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Is it possible to revert a global repository to local one and why?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What is parallel processing in informatica?
What is the difference between informatica 7.0 and 8.0?
