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
- 26433 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
How an expression transformation differs from aggregator transformation?
How does a sorter cache works?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What does role playing dimension mean?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What is informatica worklet?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Separate from a database, an information bazaar, and an information stockroom?
How do you promote a non-reusable transformation to reusable transformation?
what is diff b/t sorter t/r and agg have the option sorter property...
What is the difference between informatica 7.0 and 8.0?
How can we use mapping variables in informatica? Where do we use them?
Different qualification between a related rotate toward the sky and isolates look upward?
How to open an older version of an object in the workspace?
What is the fact table?
