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
- 15316 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
What is dynamic cache?
how to load rows into fact table in data warehouse
What is informatica?
define galaxy repository in informatica
Is it possible to create multiple domains on a single Informatica server?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is event and what are the tasks related to it?
explain about unit testing? in real time?
What is workflow? What are the components of the workflow manager?
Explain lookup transformation source types in informatica
Briefly explain the aggregator transformation?
How to extract sap data using informatica? What is abap? What are idocs?
is it possible to index the data in cache of lkp transformation ?
What do you mean by filter transformation?
What is the need for an etl tool?
