Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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 .

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


Please Help Members By Posting Answers For Below Questions

What is the difference between router and filter?

1175


What is Index Caches size?

1064


can you please explain me pre session and post session options?

7441


Differences between version 7.x and 8.x.

1852


wf dont have integration severances how you can run?

1891


To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1065


list out all the transformations which use cache?

1129


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 ?

7104


How to Create a folder using pmrep command?

1122


What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

1088


scenario where i can use only concurrent execution of workflow.

3087


How to elaborate powercenter integration service?

1086


How to load the data from people soft hrm to people soft erm using informatica?

958


How might you approve all mappings in the archive all the while?

968


Name at least 5 different types of transformations used in mapping design and state the use of each.?

1104