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 is a surrogate key?

1068


What is the way to execute pl/sql script using informatica mapping?

1584


What are the different ways to implement parallel processing in informatica?

1399


What is the procedure for creating independent data marts from informatica 7.1?

1049


What is Index Caches size?

1097


Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1308


Please let me know how to make Data masking in informatica..

1701


What is powercenter on grid?

1168


On which transformations you created partitions in your project?

1325


What do you mean by worklet?

1051


Separate from an archive server and a powerhouse?

947


Parameter and variable differences

2050


Explain scd type 3 through mapping.

967


What is dimensional table?

1055


Differentiate between source qualifier and filter transformation?

1567