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
- 15041 Views
- Cap Gemini, CTS, I also Faced
- E-Mail Answers
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 |
How can i catch the Duplicate Rows From SorterTrans in a Seperate Target Table ?
How to extract sap data using informatica? What is abap? What are idocs?
How many numbers of sessions can one group in batches?
What is the different lookup cache(s)?
In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?
I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
how remove 1st 3 records & last 3 records in informatics
When do you use mapping parameters? (In which transformations)
What are the different types of schemas?
After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, can you map these three ports directly to target?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Teradata 
