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

What is exact use of 'Online' and 'Offline' server connect Options while defining Work flow in Work flow ?

1 Answers  


source name sal aaaa 2000 bbbb 3000 abcd 5000 Target name sal aaaa 2000 bbbb 3000 abcd 5000 total 10000 how to get total as new row and sum as 10000 thanks

4 Answers   Polaris,


What are teh different tasks that can be created in workflow manager?

1 Answers   NIIT,


write s sql query following table some duplicate present i want unique one column duplicate another column display? name id a 1 a 1 b 2 b 2 c 3 i want the required output like unique duplicate name id name id a 1 a 1 b 2 b 2 c 3

4 Answers   Bank Of America,


What all are steps in up gradation of Informatica server?

0 Answers  






To achieve the session partition what r the necessary tasks u have to do?

1 Answers  


What are roles and groups and benefits of using them?

0 Answers  


Different qualification between a related rotate toward the sky and isolates look upward?

0 Answers  


What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?

1 Answers  


How to compare Source and Target table, without using dynamic lookup?

4 Answers  


How will u find weather dimension table is big in size of a fact table?

1 Answers  


when we dont use aggregator in mapping ?

2 Answers   CSC,


Categories