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
- 7163 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
Write the unconnected lookup syntax and how to return more than one column.
What are the types of schemas we have in data warehouse and what are the difference between them?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What is informatica metadata and where is it stored?
What are mapplets? How is it different from a Reusable Transformation?
What are the types of caches in lookup?
What is standalone command task?
Explain pushdown optimization and types in informatica
4 yrs etl devloper roles and responsibilities?any body give solutions
Why update strategy and union transformations are active? Explain with examples.
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
While migrating the data from one environment to another environment how would you manage the connections?
Informatica settings are available in which file?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
How can a transformation be made reusable?
