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 |
Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..
Define mapping and session?
What are the types of data that passes between informatica server and stored procedure?
Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?
What are roles and groups and benefits of using them?
Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?
Describe two levels in which update strategy transformation sets?
How can one identify whether mapping is correct or not without connecting session?
My i/p is like below 1,2,3,4,5,6,7,8,9,10....100 I want that to be populated in two o/p as below o/p-1: 10,20,30,40,50,60,70,90... o/p-2: 11,21,31,41,51,61,71,81,91.... How to do it in ingotmatica...
hi all hi have flat file like below my requirement is empid,ename,sal,loc 101,vamshi,5000,hyd 101,vamshi,5020,hyd 201,raju,5000,hyd 202,ram,4000,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd i want the o/p like this in one target 201,raju,5000,hyd 202,ram,4000,hyd and in second target 101,vamshi,5000,hyd 101,vamshi,5020,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd
why we use stored procedure transformation?
There are 4 flat files with number of records as indicated below. Which files should be picked first for joining using joiners so as to get best performance. File A - 1000 records File B - 100 records File c - 10000 records File D - 10 records Please explain. Thanks and Regards,