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
- 24950 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
What is union transformation?
Explain lookup transformation in informatica
What is the difference between Active and Passive transformation?
Write the prerequisite tasks to achieve the session partition?
What is an active transformation?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
what is unit testing?tell me proceedure
which one is better performance wise joiner or look up
How union transformation is used?
According to his methodology what all you need before you build a datawarehouse
how to load dimension table and fact table. plz tell me the steps.
How would you copy the content of one repository to another repository?
Where are the source flat files kept before running the session?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
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?
