I want expect first and last record remaining all records will be loaded into target? which transformations we can use?
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 pmcmd command?
How do you load alternate records into different tables through mapping flow?
Under what condition selecting sorted input in aggregator may fail the session?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What do you mean by enterprise data warehousing?
How do you convert single row from source into three rows into target?
Describe expression transformation?
What are the designer tools for creating transformations?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Explain what transformation and how many are there in informatica?
Suppose we do not group by on any ports of the aggregator what will be the output?
What is a transaction control transformation?
How might one distinguish in the case of mapping is right or not without associating session?
difference between informatica 8.1.1 and 8.6
how tokens will generate?