Interested to Buy Any Domain ? << Click Here >> for more details...
How to load last 10 records of flat file in to the target?
- 5 Answers
- 24991 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
How are indexes created after completing the load process?
What are the differences between a connected lookup and unconnected lookup?
What is rank transformation?
What are junk dimensions?
Differentiate between reusable transformation and mapplet.
What are the informatica performance improvement tips
Explain what are the different versions of informatica?
Explain the difference between a data warehouse and a data mart?
What are connected or unconnected transformations?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
How might one distinguish in the case of mapping is right or not without associating session?
What is target designer and target load order?
State the limitations where we cannot use joiner in the mapping pipeline?
Can you use flat files in Mapplets.
is it possible to index the data in cache of lkp transformation ?
