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
- 8867 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
How can you differentiate between powercenter and power map?
How do you load first and last records into target table?
hi real timers . iam waiting for ur reply regarding ETL TESTING
What is a code page?
What is pmcmd command?
can we override a native sql query within informatica? How do we do it?
Define enterprise data warehousing?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How can we remove the duplicates from flat file source?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
How can you increase the performance in joiner transformation?
What are the conditions needed to improve the performance of informatica aggregator transformation?
Enlist the differences between database and data warehouse.
