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
Which is the best place to learn Informatica Powercenter Online Training?
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?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
what is constraint based loading
How to delete first 3 rows & last 3 rows in target table in informatica
HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND REMAINING TO OTHER TARGET?
Describe two levels in which update strategy transformation sets?
What are junk dimensions?
what transformations are used for Variable port?
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
How to convert multiple rows to single row (multiple columns) in informatica