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
What is the difference between router and filter?
What is Index Caches size?
can you please explain me pre session and post session options?
Differences between version 7.x and 8.x.
wf dont have integration severances how you can run?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
list out all the transformations which use cache?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
How to Create a folder using pmrep command?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
scenario where i can use only concurrent execution of workflow.
How to elaborate powercenter integration service?
How to load the data from people soft hrm to people soft erm using informatica?
How might you approve all mappings in the archive all the while?
Name at least 5 different types of transformations used in mapping design and state the use of each.?