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
Please let me know how to make Data masking in informatica..
Mention few power centre client applications with their basic purpose?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What is InformaticaPowerCenter?
How to use pmcmd utility command?
Explain what is informatica metadata and where is it stored?
where to store informatica rejected data? How to extract the informatica rejected data?
Is it possible to use a client with different version than that of its Informatica server?
What is a repository manager?
r u done any partitions in ur project?
Where can we find the throughput option in informatica?
write a query to retrieve the latest records from the table sorted by version(scd)
Under which circumstances, informatica server creates reject files?
What is a mapplet/worklet in informatica?
Define filter transformation?