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

Which is the best place to learn Informatica Powercenter Online Training?

1 Answers  


i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table: pls full details

8 Answers   L&T, TCS, UnitedHealth Group, Wipro,


What is standalone command task?

0 Answers  


Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

0 Answers   HCL,


what is constraint based loading

2 Answers   IBM,






How to delete first 3 rows & last 3 rows in target table in informatica

6 Answers   TetraSoft,


HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND REMAINING TO OTHER TARGET?

6 Answers  


Describe two levels in which update strategy transformation sets?

1 Answers  


What are junk dimensions?

0 Answers  


what transformations are used for Variable port?

2 Answers  


there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation

3 Answers  


How to convert multiple rows to single row (multiple columns) in informatica

0 Answers   Informatica,


Categories