Interested to Buy Any Domain ? << Click Here >> for more details...
how remove 1st 3 records & last 3 records in informatics
- 4 Answers
- 9743 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
Repository user profiles
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What is informatica?
What is different between the data warehouse and data mart?
Mention some types of transformation?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Differences between connected and unconnected lookup?
How to create a non-reusable instance of reusable transformations?
How can one identify whether mapping is correct or not without connecting session?
Reusable transformation and shortcut differences
What is incremental aggregation?
What is a transaction control transformation?
how to create user defined function (udf) in informatica
What are junk dimensions?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
