write a sql query following source?
subject mark
maths 30
science 20
social 80
requird output
maths science social
30 20 80
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Answer / keshava
We can use pivot finction on 11g instead of multiple
decodes.
Is This Answer Correct ? | 0 Yes | 0 No |
how to duplicates from expression transformation without using sorter before that
where to store informatica rejected data?
I have a source as flat file and having data like ""TCS"MUMBAI" and i want output like TCS MUMBAI,the length of the data in the rows is variable.how can you fix it?
source table have 3 records? and it is sucessfully loaded into target. and 4more records is added in to source .that means 7 records now in source. we have to load the remaining 4 records into the same trgt table with maintian top 3 records. how ?can any one give me the data flow of this logic plz?
how to work with mapplet designer in informatica?
What is confirmed dimension with scenario
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
how lookup is acting as both active and passive ? how is it possitble?
What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?
tell me some dimension tables names in banking domain informatica project(dont tell like depends on project, tell me names of dimension and fact table names in your project)?
which quality process u can approach in ur project
We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?