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...

How to delete first 3 rows & last 3 rows in target table in
informatica

Answer Posted / civa

take seq trns and drag nextval port into exp trns and also
drag sq ports to exp

in exp delete from emp where nextval= 1 or 2 or 3 and
nextval=count(empno)-1 or count(empno)-2 or count(empno)-3

Is This Answer Correct ?    3 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is mapplet in informatica?

983


Which version configuration tool used in ur project?

3184


What are the main features of Oracle 8i with context to datawarehouse?

2053


What is workflow? What are the components of the workflow manager?

1070


Different qualification between a related rotate toward the sky and isolates look upward?

931


in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

1987


Please let me know how to make encryption and decryption with example?

1848


What are session parameters ? How do you set them?

1774


What are the informatica performance improvement tips

1019


How do you take back up of repository?

1094


How can we improve session performance in aggregator transformation?

1041


Explain how to import oracle sequence into informatica?

953


What are the issues you have faced in your project? How did you overcome those issues?

2292


What is exclusive and normal mode for repository services?

1063


How to differentiate between the active and passive transformations?

1078