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
- 15029 Views
- Cap Gemini, CTS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How does a rank transform differ from aggregator transform functions max and min?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
How to delete duplicate row using informatica?
what is SDLC way of code development?
What is lookup transformation?
What is aggregate cache in aggregator transformation?
what is informatica metadata?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Explain your project of banking domian.
What is the difference between stop and abort in informatica
Global and Local shortcuts. Advantages.
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
scenario where i can use only concurrent execution of workflow.
