Interested to Buy Any Domain ? << Click Here >> for more details...
how remove 1st 3 records & last 3 records in informatics
- 4 Answers
- 9549 Views
- TetraSoft, I also Faced
- E-Mail Answers
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
What is a joiner transformation?
Describe the impact of several join conditions and join order in a joiner transformation?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
How can we use batches?
What is a predefined event?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
explain about unit testing? in real time?
What is the scenario which compels informatica server to reject files?
Mention a few design and development best practices for informatica?
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.
How can we delete duplicate rows from flat files?
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?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is the surrogate key?
How to update or delete the rows in a target, which do not have key fields?
