I want expect first and last record remaining all records will be loaded into ta

Categories >> Software >> Data Warehouse >> Informatica
Suggest New Category

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

Question Posted / guest

6 Answers
15609 Views
Cap Gemini, CTS, I also Faced
E-Mail Answers

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