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
- 24767 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
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
State the limitations where we cannot use joiner in the mapping pipeline?
Enlist the various types of transformations.
What is the cumulative sum and moving sum?
How can you validate all mappings in the repository simultaneously?
Why update strategy and union transformations are active? Explain with examples.
What is the function of union transformation?
What is resilience time?
What is a difference between complete, stop and abort?
Describe expression transformation?
tell me the rules and responsblites in our project(my project is development)
What is incremental aggregation?
differences between service based and product based?
What is an aggregator transformation?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
