Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 0 Answers
- 2560 Views
- TCS, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
How to Join Tables my Source is having 15 table target is one?
can anyone suggest best free Talend data integration training online
without dynamic lookup how to insert new rows and update existing rows?
What is the method of seperating unique and duplicate records in session level?
2 Answers Emphasis, JBL, Wipro,
What is transformation?
What is aggregate cache in aggregator transforamtion?
WHAT IS USE OF SQL OVERRIDE IN SOURCE QUALIFIER? chandumba2005@gmai.com
Does Facttable Normalized or Denormalized?
If there are more than one sessions running parallel in a worklet, which will be the last session ?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000
Explain the tuning lookup transformation - informatica
Teradata 
