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
- 26206 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 might you approve all mappings in the archive all the while?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
Describe data concatenation?
What is the meaning of up gradation of repository?
how to load rows into fact table in data warehouse
Why union transformation is an active transformation?
In how many ways we can create ports?
Write the prerequisite tasks to achieve the session partition?
What will be the approach?
What is meant by incremental aggregation?
What are the types of caches in lookup?
Enlist the differences between database and data warehouse.
What are the different types of repositories created using informatica?
How you know when to use a static cache and dynamic cache in lookup transformation?
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
