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?
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 incremental aggregation?
Enterprise data warehouse your projects phase by phase explain?
How do you set a varible in incremental aggregation
Quickly characterize reusable change?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
Different circumstance which drives informatica server to expel records?
Explain what transformation and how many are there in informatica?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Which means the first record should come as last record and last record should come as first record and load into the target file?
server hot-ws270 is connect to Repository B. What does it mean?
pmscmd startworkflow -sv
What is update strategy transform?
What are the mapping parameters and mapping variables?
Is there any way to read the ms excel datas directly into informatica?
Can anyone tell me the new features in Informatica 9 Version?