write a sql query following source?
subject mark
maths 30
science 20
social 80
requird output
maths science social
30 20 80
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
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
Explain the use of aggregator cache file?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
can you please explain me pre session and post session options?
Define filter transformation?
can we override a native sql query within informatica? Where do we do it?
Explain the etl program with few examples.
The question was on time stamp. what is the difference between HH and HH24 when to use when.
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
How to generate sequence numbers?
What is a predefined event?
How you know when to use a static cache and dynamic cache in lookup transformation?
What is the need of etl tools?
How do you update the records with or without using update strategy?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?