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 / gyana

yes..very nice question

---------------------------
after SQ take two pipeline::::one to find 1st 3 record and another to find last 3 record
------------------------------------------
(1) from SQ connect an expression and into that expression connect a sequence generator to generate sequence.
After expression put a filter t/r (seq>=4) and pass to one target instance(T1)
(2) from SQ connect an expression and into that expression connect a sequence generator to generate sequence.
now take a RANK t/r and set the property as(bottom performer,rank on port SEQ,NUMBER OF rank=3).connect that to second target instance (T2)..it will give u last 3 records..

if any wrong pls send me mail......(gyana.informatica@gmail.com)

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the different kinds of facts.

1023


What are the types of caches in lookup? Explain them.

1013


What are the new features of informatica 9.x developer?

1030


what is the size of u r source(like file or table)?

2310


What do mean by local and global repository?

1282


how tokens will generate?

2249


explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2200


Describe an informatica powercenter?

1194


permutations of mapplet

2550


What is a standalone command task?

1256


How to do unit testing in informatica?

1229


What do you mean by channel change?

1108


How to call shell scripts from informatica?

1043


Explian the Process of deployment groups in informatica

1102


Explain constraint based loading in informatica

1157