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 are the different ways to implement parallel processing in informatica?

1429


What do you mean incremental aggregation?

1085


what is mean by complex business rule ?

2163


How we can create indexes after completing the load process?

1163


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

1179


What is main use of mapplet?

1136


How can a transformation be made reusable?

1174


where to store informatica rejected data? How to extract the informatica rejected data?

1008


Explain the shared cache and re-cache?

1124


Define sessions in informatica etl?

1041


What is primary and backup node?

1137


can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2525


Write the prerequisite tasks to achieve the session partition?

1163


What is parallel processing in informatica?

1718


What is Index Caches size?

1121