How to eliminate 1st and last rows from the source and load
the inbetween rows.
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 many transformations can be used in mapplets.
Differentiate between router and filter transformation?
How do we call shell scripts from informatica?
Quickly characterize reusable change?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What is complex mapping?
Mention few advantages of router transformation over filter transformation.
Differences between version 7.x and 8.x.
Explain about Informatica server process that how it works relates to mapping variables?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
How can we handle two sessions in informatica?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Which transformation is needed while using the Cobol sources as source definitions?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
How would you join a node to the already existing domain?