Hi,
source data is
col1 values are 5,6,7
col2 are 3,2,1
col3 are 8,9,10
and i want to get target as
col1 5,6,7
col2 1,2,3
col3 8,9,10
how to do this one?
Answer Posted / benz
order by clause
Select * from tablename orderby col2 asc;
Is This Answer Correct ? | 2 Yes | 6 No |
Post New Answer View All Answers
What is the use of an aggregator cache file?
What is the need of etl tools?
What is workflow? What are the components of the workflow manager?
Clarify the utilization of aggregator cache record?
Implementation methodology
How can you validate all mappings in the repository simultaneously?
in reporting we add some new objects,how we get the count of the newly added objects to the report
What is the use of transformation?
what is $$$$?
What are the differences between joiner transformation and source qualifier transformation?
What is the benefit of partitioning a session?
Write the unconnected lookup syntax and how to return more than one column.
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Explain sessions?