Interested to Buy Any Domain ? << Click Here >> for more details...
One flatefile it contains some data but i want to dont want
to load first and last record ..how it is? can u tell me
complete logic?
- 2 Answers
- 6705 Views
- I also Faced
- E-Mail Answers
Answer Posted / ashok nidamanuri
We can implement like this
1)Take sequence genarator transformation and get sequence
of no's for each and every record
2)Then in expression take two output port's like out_min
and out_max.Assign Min and Max functions to corrsponding
output ports then u will get Min and max value of the
records
3)Take filter transformaton and filter those two records in
filter tarnsformation.
try with this!!!!!!!!!!!!!!!!!!!
| Is This Answer Correct ? | 3 Yes | 6 No |
Post New Answer View All Answers
What is workflow monitor?
What are data-driven sessions?
How many dimensions are there in informatica?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
How to do unit testing in informatica?
How do you load first and last records into target table?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
what is diff b/t sorter t/r and agg have the option sorter property...
Explain the different lookup methods used in informatica?
What is an expression transformation in informatica?
Scheduling properties,whats the default (sequential)
Plz can any one say me how to get the informatica certification materials and dumps
What will be the approach?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
what is the hint? how to use it to reduce the query processing in program?
