Interested to Buy Any Domain ? << Click Here >> for more details...
how remove 1st 3 records & last 3 records in informatics
- 4 Answers
- 9757 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
How to Create a folder using pmrep command?
Why union transformation is an active transformation?
What are the different components of powercenter?
How will the document be delivered to me?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
Differentiate between source qualifier and filter transformation?
What are some examples of informatica etl programs?
tell me 5 session failure in real time how can you solve that in your project?
Clarify the utilization of aggregator cache record?
what are 3 tech challenges/ common issues you face?
What are the tuning techniques you applied during your last project
Why update strategy and union transformations are active? Explain with examples.
What is a shortcut and copy in Informatica and how two are different with each other?
where to store informatica rejected data?
Where are the source flat files kept before running the session?
