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
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 |
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 |
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 |
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 |
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 |
What is substr in informatica?
How to join three sources using joiner? Explain though mapping flow.
What all are steps in up gradation of Informatica server?
Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?
can u any challenge your project?
Hi, Can someone send me the DWH and Informatica FAQ's at priti.singh84@gmail.com Thanks in Advance, preeti
How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What is pmcmd command?
Examples of Fatal & Non-Fatal error?
what is song in infrmatica...?
What is the format of informatica objects in a repository?