Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

what is the size of u r source(like file or table)?

2310


In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

2108


What is a shortcut and copy in Informatica and how two are different with each other?

1241


What are mapplets?

1328


Explain the tuning lookup transformation - informatica

1047


Define mapping and session?

1091


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?

2173


Explain how to import oracle sequence into informatica?

1071


How can we remove the duplicates from flat file source?

1075


Explain the features of connected and unconnected lookup.

976


What are the main features of Oracle 8i with context to datawarehouse?

2161


draw informatica architecture 8.6 ?

3932


Explain what are the different versions of informatica?

1146


how we can load rejected record's at run time?(not through bad files)

2431


What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7588