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
tell me the push down optimization
i have 50500 records in my source.if wf run for the first time it will load 1000 records into 1 tgt,if runs second time it will load to another tgt.targets are FF and it is need to be created dynamically.how many tgt will be created and how?
my source contain data like this eno ename phno 100 john 9989020508 101 ram 7246599999 i want to load the data into target is eno name phno 100 john (998)-9020-508 102 ram (724)-6599-999.
What is a command that used to run a batch?
Filter transformation in the condition one of the data is NULL would the record be dropped.
What is informatica worklet?
Hello...... How can i set my mapping as read-only? Please answer me. Advance thanks
How to send duplicates to one target and unique rows to one target?target is empty
how to declare array in plsql?
What is the difference between lookup override and souce qualifier override ?
write a query to remove null value follwing table? col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output col1 col2 col3 dinesh suresh prakesh
how do the project develops? pls specify right from the start to end in step by steps.