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

I want expect first and last record remaining all records will be loaded into target? which transformations we can use?

Answer Posted / kuldeep singh rathore

Src->sq->seq_gen->exp\_joiner->flt->tgt
---------->agg/


create a new port for count in agg and one dual port we assign 1 in that
and in exp also we add a port dual =1
we give condition in joiner on dual port
Write a logic in FLTR as "SEQ_PORT!=1 AND (count-SEQ_PORT)!=0"

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain why we use partitioning the session in informatica?

1161


What is olap (on-line analytical processing?

1109


What do you understand by a term domain?

1171


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

2068


How to do unit testing in informatica?

1226


4 yrs etl devloper roles and responsibilities?any body give solutions

2243


how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2504


What are multi-group transformations?

1161


Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1157


Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

1337


How do you set a varible in incremental aggregation

1939


Where can we find the throughput option in informatica?

1105


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?

1555


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

1134


What is different between the data warehouse and data mart?

1111