How to load last 10 records of flat file in to the target?
- 5 Answers
- 23490 Views
- iNautix, I also Faced
- E-Mail Answers
Answer Posted / kalpesh radadia
SQ---- Exp ---- Sorter----Exp --- Filter---Sorter ---
Target.
Connect the source qualifier transfromation to an
expression transformation. In the expression
transformation, create the below ports:
v_cnt (variable port) = v_cnt+1
o_cnt (output_port) = v_cnt
Connect the expression transformation to the sorter
transformation. Sort the rows on the o_cnt port in
descending order.
Now connect the sorter transformation to the expression
transformation (do not connect o_cnt port).
Again Connect to expression transformation create the ports
mentioned above
v_cnt (variable port) = v_cnt+1 o_cnt
(output_port) = v_cnt
Connect to a filter transformation and specify the filter
condition as o_cnt<=N
Connect the expression transformation to the sorter
transformation. Sort the rows on the o_cnt port in
descending order.
Connec to the target
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Can we create multiple integration service on single repository?
What is the function of look up transformation?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What are the settings that you use to configure the joiner transformation?
can anyone explain me about retail domain project in informatica?
how to create user defined function (udf) in informatica
What are the main issues while working with flat files as source and as targets ?
What is transformation?
While migrating the data from one environment to another environment how would you manage the connections?
How to go to the older version for a mapping?
what is the -ve test case in your project.
What is the difference between stop and abort in informatica
What is data movement mode in Informatica and difference between them?
What is the sequence generator transformation in informatica?
What are the different clients of powercenter?
