how remove 1st 3 records & last 3 records in informatics
Answer Posted / gyana
yes..very nice question
---------------------------
after SQ take two pipeline::::one to find 1st 3 record and another to find last 3 record
------------------------------------------
(1) from SQ connect an expression and into that expression connect a sequence generator to generate sequence.
After expression put a filter t/r (seq>=4) and pass to one target instance(T1)
(2) from SQ connect an expression and into that expression connect a sequence generator to generate sequence.
now take a RANK t/r and set the property as(bottom performer,rank on port SEQ,NUMBER OF rank=3).connect that to second target instance (T2)..it will give u last 3 records..
if any wrong pls send me mail......(gyana.informatica@gmail.com)
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Explain the different kinds of facts.
What are the types of caches in lookup? Explain them.
What are the new features of informatica 9.x developer?
what is the size of u r source(like file or table)?
What do mean by local and global repository?
how tokens will generate?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Describe an informatica powercenter?
permutations of mapplet
What is a standalone command task?
How to do unit testing in informatica?
What do you mean by channel change?
How to call shell scripts from informatica?
Explian the Process of deployment groups in informatica
Explain constraint based loading in informatica