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
How can we update a record in the target table without using update strategy?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What are session parameters ? How do you set them?
How can we store previous session logs?
can u give example for factless fact table
Explain the pipeline partition with real time example?
In how many ways we can create ports?
What is the procedure for creating independent data marts from informatica 7.1?
Differentiate between source qualifier and filter transformation?
What do you mean by enterprise data warehousing?
How can you validate all mappings in the repository simultaneously?
Tell me about Propagate functions in informatica
What is the Process to creating lookup transformation in informatica
Differentiate between a repository server and a powerhouse?
What are the components of Informatica? And what is the purpose of each?