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

One flatefile it contains some data but i want to dont want
to load first and last record ..how it is? can u tell me
complete logic?

Answer Posted / ashok nidamanuri

We can implement like this
1)Take sequence genarator transformation and get sequence
of no's for each and every record
2)Then in expression take two output port's like out_min
and out_max.Assign Min and Max functions to corrsponding
output ports then u will get Min and max value of the
records
3)Take filter transformaton and filter those two records in
filter tarnsformation.

try with this!!!!!!!!!!!!!!!!!!!

Is This Answer Correct ?    3 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is incremental aggregation?

1014


Enterprise data warehouse your projects phase by phase explain?

1856


How do you set a varible in incremental aggregation

1826


Quickly characterize reusable change?

1058


what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1908


Different circumstance which drives informatica server to expel records?

915


Explain what transformation and how many are there in informatica?

890


Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

991


Which means the first record should come as last record and last record should come as first record and load into the target file?

1021


server hot-ws270 is connect to Repository B. What does it mean?

2439


pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1442


What is update strategy transform?

1015


What are the mapping parameters and mapping variables?

1087


Is there any way to read the ms excel datas directly into informatica?

978


Can anyone tell me the new features in Informatica 9 Version?

2032