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 remove 1st 3 records & last 3 records in informatics

Answer Posted / venky

after sq transformation use exp transformation in that add
one port,and take seq generator trans and its properties
reset is enable,and link to the port in exp trans,after
that take filter trans and condition port>3,after that use
sorter trans in that take port desc,after that take exp
trans and create another new port,after that take seq gen
trans in properties resert as enable and link to the new
port,afer that use filter trans condition new port>3 and
connect to target.

this is the process u can do u wil get the result.pls try it
correctly

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are connected or unconnected transformations?

1167


What is parallel processing in informatica?

1783


What is a router transformation?

1207


How many dimensions are there in informatica?

1131


Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

2016


How would you copy the content of one repository to another repository?

1058


What is the difference between stop and abort in informatica

1140


What are the popular informatica products?

1052


What could be the possible resons of locks by user?

1138


What is a grid in Informatica?

1112


What is dimensional table? Explain the different dimensions.

1241


Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1135


Mention few power centre client applications with their basic purpose?

993


What is a predefined event?

1131


What are the types of presistent cache in look up tr.

2104