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
- 26181 Views
- Syntel, I also Faced
- E-Mail Answers
Answer Posted / manoj subramanian
I have done it using sequence generator,rank and filter transformation.
Filtering first record:
Generated sequence no using sequence transformation and given
as input to rank transformation.In properties selected
top and no of ranks as maximum rank allowed in informatica
then followed by filter transformation with filter condition
as rankindex<>1.
Filtering last Record:
Followed by another set of rank and filter wit rank property as bottom.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How can you increase the performance in joiner transformation?
Where can we find the throughput option in informatica?
What is union transformation in informatica?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What is the difference between informatica 7.0 and 8.0?
Define pmcmd command?
Explain scd type 3 through mapping.
wat are deployement groups in informatica, how it will be used for developers
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
what is diff b/t sorter t/r and agg have the option sorter property...
Partition, what happens if the specified key range is shorter and longer
What happens when a session fails and you click on recover?
What you know about transaction control transformation?
What is a sorter transformation?
What is rank transform?
