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?

Answers were Sorted based on User's Feedback



I want expect first and last record remaining all records will be loaded into target? which transfor..

Answer / ravikumar2614

Data flow like:
SRC-->SQ-->SEQ_GEN-->EXP-->AGGR-->FLTR-->TGT

create new port as M_PORT in Exp and leave empty.
write a logic in AGGR for M_PORT as MAX(SEQ_PORT)
Write a logic in FLTR as "SEQ_PORT!=1 AND M_PORT-SEQ_PORT!=0"

If my approach is wrong correct me on ravi.infop@gmail.com

Is This Answer Correct ?    14 Yes 5 No

I want expect first and last record remaining all records will be loaded into target? which transfor..

Answer / tanay

You can use Head and Tail commands in UNIX to achieve the
same. Please correct me if i am wrong.

Is This Answer Correct ?    5 Yes 2 No

I want expect first and last record remaining all records will be loaded into target? which transfor..

Answer / sudha

Src->sq->seq_gen->exp->agg->flt->tgt

create new port as M_PORT in Exp and leave empty.
write a logic in AGGR for M_PORT as MAX(SEQ_PORT)
Write a logic in FLTR as "SEQ_PORT!=1 AND SEQ_PORT!=m_port"

Please correct me if am wrong.

Is This Answer Correct ?    5 Yes 2 No

I want expect first and last record remaining all records will be loaded into target? which transfor..

Answer / rajesh

Use head and tail command(Pre session command) write it into two files.Use transformation to read that files as per your requirement

Is This Answer Correct ?    0 Yes 0 No

I want expect first and last record remaining all records will be loaded into target? which transfor..

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

I want expect first and last record remaining all records will be loaded into target? which transfor..

Answer / ashok

Sequence Generator

Is This Answer Correct ?    1 Yes 7 No

Post New Answer

More Informatica Interview Questions

Hi, Can you please send me the Informatica 8 certification exam dumps to my email id rwork.san@gmail.com Thanks, Revathi.

6 Answers   CTS,


can anyone explain me about sales project in informatica?

8 Answers   MBT, Satyam,


One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

0 Answers   TCS,


how do u tune queries?

1 Answers  


Hi, Can anyone just give me the list of all versions of Informatica ? Advance Thanks

2 Answers   IBM,


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

0 Answers   TCS,


What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?

8 Answers   TCS,


What is update strategy transform?

0 Answers  


hw cn v elimate dublicate values from lookup without overriding sql?

7 Answers   CTS,


What is joiner transformation?

0 Answers  


I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?

3 Answers  


What is Session and Batches?

0 Answers   Informatica,


Categories