i have n number of records in my source, i want first and
last record to my target. how can u implement this scenario .
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
Design time, run time. If you don't create parameter what will happen
Explain dynamic target flat file name generation in informatica
Define the various join types of joiner transformation?
What are pre and post-session shell commands?
How to elaborate powercenter integration service?
What is workflow manager?
Explain pushdown optimization $pushdownconfig parameter - informatica
Can we change Dynamic to Static or Persistent cache? If so what happens?
permutations of mapplet
Enlist some properties of sessions.
Explain the different kinds of facts.
What are the measure objects?
what is the hint? how to use it to reduce the query processing in program?
Explain the features of connected and unconnected lookup.
What is the use of code page?