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
- 15375 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
Can we override a native sql query within informatica?
tell me about your project functionality
What is joiner transformation?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
How are indexes created after completing the load process?
What are the different components of powercenter?
is it possible to index the data in cache of lkp transformation ?
4 yrs etl devloper roles and responsibilities?any body give solutions
Describe data concatenation?
what are 3 tech challenges/ common issues you face?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How union transformation is used?
can we override a native sql query within informatica? Where do we do it? How do we do it?
