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

can you use flat file for lookup table?why?

2 Answers   HCL,


what r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy

2 Answers   TCS,


What is workflow manager?

0 Answers  


How to fix the etl bugs..Tell me the process?

1 Answers   IBM,


What if the source is a flat-file?

0 Answers  


There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?

1 Answers   Accenture,


i want to convert below src into target src is as follows maths 30 science 20 social 81 i want data in trg like below maths science social 30 20 81

2 Answers   HCL, HP,


Can we create a Integration service without a Repository service and vice versa?

0 Answers  


Explain pushdown optimization $pushdownconfig parameter - informatica

0 Answers   Informatica,


What are the reusable transforamtions?

1 Answers  


While migrating the data from one environment to another environment how would you manage the connections?

0 Answers  


I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.

4 Answers   Cap Gemini, IBM,


Categories