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 want load the data into target with out 1st and last record.

Answer Posted / sravanthi

In source qualifier Transformation we can write the
following query.....

select rownum,x.* from (select rownum rn,e.* from emp e ) x
where rn>1 and rn<(select count(*) from emp)

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the new features of informatica 9.x in developer level?

1000


generate date / time dimension in informatica

1128


How can repository reports be accessed without sql or other transformations?

1223


What is pmcmd command?

1125


What is Data Caches size?

1091


What is target designer and target load order?

1109


What is workflow manager?

1053


What do you mean incremental aggregation?

1082


Define update strategy?

1233


Difference between Data and Index Caches?

1141


How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1583


What is rank transform?

1000


What is a repository manager?

1095


Enterprise data warehouse your projects phase by phase explain?

1924


What is a surrogate key?

1085