write sql query following table
quarter sales
q1 1000
q1 2000
q1 3000
q1 4000
q2 5000
q2 6000
q2 7000
q2 8000
q3 1000
q3 2000
q3 3000
q3 4000
q4 5000
q4 6000
q4 7000
q4 8000
i want the output format like
q1 q2 q3 q4
1000 5000 1000 5000
2000 6000 2000 6000
3000 7000 3000 7000
4000 8000 4000 8000
Answer Posted / parthu
It may possible with Normalizer transformation.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what is the size of u r source(like file or table)?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What is a shortcut and copy in Informatica and how two are different with each other?
What are mapplets?
Explain the tuning lookup transformation - informatica
Define mapping and session?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Explain how to import oracle sequence into informatica?
How can we remove the duplicates from flat file source?
Explain the features of connected and unconnected lookup.
What are the main features of Oracle 8i with context to datawarehouse?
draw informatica architecture 8.6 ?
Explain what are the different versions of informatica?
how we can load rejected record's at run time?(not through bad files)
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?