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 vertical to horiozontal following table

id name
1 100
2 dinesh
3 india
1 101
2 suresh
3 india
1 103
2 prakesh
3 usa

i want output like

id name country
100 dinesh india
101 suresh india
103 prakesh usa


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

How to differentiate between the active and passive transformations?

0 Answers  


Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

0 Answers  


Which is the t/r that builts only single cache memory?

0 Answers  


if soource is having 10 records how will u insert 20 records to target

6 Answers   HCL,


scd methodology?

2 Answers  


Which files are created during the session rums by informatics server?

0 Answers  


Hi,tell me the system testing and Integration Testing in the Informatica ? Thank You

2 Answers   TCS,


Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400

7 Answers   iGate,


Hi All, I've 110 records in my table but 101 records contains an error. When I run the session, I want to load the 100 records into the target. Can anyone suggest me the best solution for this... Thanks in Advance,

7 Answers   Tech Mahindra,


How are the sources and targets definitions imported in informatica designer?

0 Answers   Informatica,


whether Sequence generater T/r uses Caches? then what type of Cache it is

7 Answers   Accenture,


What is the cumulative sum and moving sum?

0 Answers  


Categories