Interested to Buy Any Domain ? << Click Here >> for more details...
i have n number of records in my source, i want first and
last record to my target. how can u implement this scenario .
- 6 Answers
- 9917 Views
- Emphasis, I also Faced
- E-Mail Answers
Answer Posted / chandrasekar
Please try the SQL query in the SQL override,
select * from emp where rownum=1 union select *
from emp where rowid=(select max(rowid) from
emp);
if it wrong means please mail to me chandranmca2007@gmail.com
| Is This Answer Correct ? | 8 Yes | 3 No |
Post New Answer View All Answers
What is mapplet in informatica?
Is stop and abort are same in informatica?
Which development components of informatica have the highest usage?
What is expression transformation?
How can one identify whether mapping is correct or not without connecting session?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is the difference between stop and abort in informatica
Define mapping and session?
Mention few advantages of router transformation over filter transformation.
Explain the difference between mapping parameter and mapping variable?
What are the different types of olap? Give an example?
Design a mapping to load a target table with the following values from the above source?
Briefly define reusable transformation?
What is the command used to run a batch?
What can we do to improve the performance of informatica aggregator transformation?
