Interested to Buy Any Domain ? << Click Here >> for more details...
How to eliminate 1st and last rows from the source and load
the inbetween rows.
- 5 Answers
- 25922 Views
- Syntel, I also Faced
- E-Mail Answers
Answer Posted / maneesh
To eliminate first row, simply use a counter in Expression and then Filter.
To eliminate the last row, make two pipelines with the same source
In first pipeline, use AGGREGATOR without any Group By ports In second pipeline, join it with the above with JOINER. Use and Outer Join and then other than that Joined row .. load all the rows.
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
EXL informatica Questions
What is the difference between STOP and ABORT options in Workflow Monitor?
Which files are created during the session rums by informatics server?
What does “tail –f” command do and what is its use as an Informatica admin.
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 .
How to load the data from a flat file into the target where the source flat file name changes daily?
What is Cognos script editor?
What is Index Caches size?
Clarify the utilization of aggregator cache record?
How can we update a record in the target table without using update strategy?
What do you mean by enterprise data warehousing?
What is session task and command task?
What is flashback table ? Advance thanks
Does an informatica transformation support only aggregate expressions?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
