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
Difference between Target-based loading and constraint-based loading?
what are the Methods For Creating Reusable Transformations?
What are multi-group transformations?
What do you mean incremental aggregation?
what is degenerated dimension?
Can informatica load heterogeneous targets from heterogeneous sources?
What are the components of Informatica? And what is the purpose of each?
Enlist some properties of sessions.
What is informatica etl tool?
How to differentiate between the active and passive transformations?
Differentiate between joiner and lookup transformation?
Plz can any one say me how to get the informatica certification materials and dumps
explain one complex mapping with logic? sales project?
How can you validate all mappings in the repository simultaneously?
If informatica has its scheduler why using third party scheduler?