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
- 9104 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
Mention few power centre client applications with their basic purpose?
Differentiate between a database and data warehouse?
Can you use flat files in Mapplets.
Can u generate reports in Informatica?
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 IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What is rank transformation in informatica
Define pmcmd command?
How to elaborate tracing level?
What are the types of schemas we have in data warehouse and what are the difference between them?
What are ETL Tools?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
