how remove 1st 3 records & last 3 records in informatics
Answer Posted / davankumar p
2 pipelines,1st pipeline sorter t/r ascending order then
rank t/r top3
2nd pipeline sorter decending order then rank top3 t/r
| Is This Answer Correct ? | 2 Yes | 7 No |
Post New Answer View All Answers
What are the restrictions of union transformation?
How to differentiate between the active and passive transformations?
what are 3 tech challenges/ common issues you face?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What is workflow? What are the components of the workflow manager?
What is decode in static cache?
Performance tuning( what you did in performance tuning)
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What are the transformations that are not supported in mapplet?
What is a joiner transformation?
Difference between Data and Index Caches?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What is mapplet in informatica?
What are the differences between oltp and olap?
During the running session, output files are created by informatica server. Enlist few of them.