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 repository manager?

1025


What are the steps involved in the migration from older version to newer version of Informatica Server?

2150


i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2174


What is a predefined event?

1134


In how many ways we can create ports?

1157


explain one complex mapping with logic? sales project?

6730


What are mapplets? How is it different from a Reusable Transformation?

1134


What is enterprise data warehousing?

1105


Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

2071


How can we use mapping variables in informatica?

1123


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

1231


What are the components of the workflow manager?

1179


Why is sorter an active transformation?

1195


What is union transformation?

1015


What is the difference between stop and abort in informatica

1142