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
- 15352 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
Under which circumstances, informatica server creates reject files?
Which transformation is needed while using the Cobol sources as source definitions?
What is a snowflake schema?
How identifying bottlenecks in various components of informatica and resolving them?
How to improve the performance of a session using sorter transformation?
Can informatica load heterogeneous targets from heterogeneous sources?
EXL informatica Questions
What are the main features of Oracle 8i with context to datawarehouse?
What is status code in informatica?
How can repository reports be accessed without sql or other transformations?
what is the complex transformation you used in informatica
Which are the different editions of informatica powercenter that are available?
What are connected or unconnected transformations?
What are the new features of Power Center 5.0?
What is persistent lookup cache?
