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
Explain why we use partitioning the session in informatica?
What is olap (on-line analytical processing?
What do you understand by a term domain?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
How to do unit testing in informatica?
4 yrs etl devloper roles and responsibilities?any body give solutions
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What are multi-group transformations?
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?
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.
How do you set a varible in incremental aggregation
Where can we find the throughput option in informatica?
pmscmd startworkflow -sv
What are mapplets? How is it different from a Reusable Transformation?
What is different between the data warehouse and data mart?