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?
- 6 Answers
- 15346 Views
- Cap Gemini, CTS, I also Faced
- E-Mail Answers
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
What is a connected transformation?
What is event and what are the tasks related to it?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
can anyone suggest best free Talend data integration training online
What is status code in informatica?
How to Create a folder using pmrep command?
How will the document be delivered to me?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
what is Active lock explain
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What are the differences between joiner transformation and source qualifier transformation?
What are the differences between source qualifier and joiner transformation?
Explain the features of connected and unconnected lookup.
Enlist few areas or real-time situations where informatica is required.
