Interested to Buy Any Domain ? << Click Here >> for more details...
My source table having some records ,i want load 1st record
and last record into one target?
- 3 Answers
- 9668 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / chandrasekar
I took the EMP table and we can use the below query in the
SQL override,
select * from emp where rownum=1 union select *
from emp where rowid=(select max(rowid) from
emp);
it will work.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Repository user profiles
How to elaborate powercenter integration service?
What is Index Caches size?
pmscmd startworkflow -sv
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Explain pushdown optimization and types in informatica
What are the types of presistent cache in look up tr.
Enlist the tasks for which source qualifier transformation is used.
How to improve the performance of a session using sorter transformation?
What do you understand by SOA of Informatica?
Where are the source flat files kept before running the session?
What could be the possible resons of locks by user?
How can we store previous session logs?
How do you promote a non-reusable transformation to reusable transformation?
What happens when a session fails and you click on recover?
