I want expect first and last record remaining all records will be loaded into target? which transformations we can use?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / tanay
You can use Head and Tail commands in UNIX to achieve the
same. Please correct me if i am wrong.
Is This Answer Correct ? | 5 Yes | 2 No |
Answer / 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 |
Answer / rajesh
Use head and tail command(Pre session command) write it into two files.Use transformation to read that files as per your requirement
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / kuldeep singh rathore
Src->sq->seq_gen->exp\_joiner->flt->tgt
---------->agg/
create a new port for count in agg and one dual port we assign 1 in that
and in exp also we add a port dual =1
we give condition in joiner on dual port
Write a logic in FLTR as "SEQ_PORT!=1 AND (count-SEQ_PORT)!=0"
Is This Answer Correct ? | 0 Yes | 0 No |
What are the mapping parameters and mapping variables?
difference between informatica 8.1.1 and 8.6
can we import source table without using source qualifier? if yes then how? if no then why?
Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.
What are the components of Informatica? And what is the purpose of each?
how we can load rejected record's at run time?(not through bad files)
Define filter transformation?
Explain about perform recovery?
There are two sessions are connected to the workflow. When the first session run load the data(employees data sum_salaries <= 1000000) into the target1. When the second session run load the data(employees data sum_salaries > 1000000) into the target2. How to achieve this?
Explain in detail about scd type 1 through mapping.
Differentiate between joiner and lookup transformation?
If I have a index defined on target table and if set it to bulk load will it work ?