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
why we r using presql&postsql in source qualifier?
What is dimensional table? Explain the different dimensions.
What is an MDDB? What is the difference between MDDBs and RDBMSs?
What is use of batch file in informatica? How many types of batch file in informatica?
what is mapping parameter and mapping variables
How to update or delete the rows in a target, which do not have key fields?
what is degenerated dimension?
What are the types of data that passes between informatica server and stored procedure?
What is the difference between Active and Passive transformation?
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
What are the restrictions of union transformation?
What is the sequence generator transformation in informatica?