Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 6 Answers
- 8917 Views
- I also Faced
- E-Mail Answers
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
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What all are steps in up gradation of Informatica server?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
Different qualification between a related rotate toward the sky and isolates look upward?
What is workflow? What are the components of workflow manager?
What is data caches/ index caches?
What are the new features of informatica 9.x developer?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
To import the flat file definition into the designer where should the flat file be placed?
What is complex mapping?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
Explain sql transformation in script mode examples in informatica
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Describe data concatenation?
