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

why we r using presql&postsql in source qualifier?

1 Answers   HP,


What is dimensional table? Explain the different dimensions.

0 Answers  


What is an MDDB? What is the difference between MDDBs and RDBMSs?

3 Answers  


What is use of batch file in informatica? How many types of batch file in informatica?

2 Answers   EXL,


what is mapping parameter and mapping variables

1 Answers   BirlaSoft,






How to update or delete the rows in a target, which do not have key fields?

0 Answers   Informatica,


what is degenerated dimension?

1 Answers   IBM,


What are the types of data that passes between informatica server and stored procedure?

1 Answers   Informatica,


What is the difference between Active and Passive transformation?

0 Answers   Informatica,


my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 4

2 Answers   Zensar,


What are the restrictions of union transformation?

0 Answers  


What is the sequence generator transformation in informatica?

0 Answers  


Categories