I want expect first and last record remaining all records will be loaded into target? which transformations we can use?
Answer Posted / sudha
Src->sq->seq_gen->exp->agg->flt->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 SEQ_PORT!=m_port"
Please correct me if am wrong.
Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
what is degenerated dimension?
What are the mapping parameters and mapping variables?
I have a flat file, want to reverse the contents of the flat file
How you prepared reports for OLAP?
What are the main features of Oracle 8i with context to datawarehouse?
How is union transformation utilized?
Explain the difference between a data warehouse and a data mart?
When do you use sql override in a lookup transformation?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
What is parallel processing in informatica?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
In how many ways we can create ports?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What is the status code in stored procedure transformation?