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
- 6800 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
Global and Local shortcuts. Advantages.
What is a node in Informatica?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What is data movement mode in Informatica and difference between them?
How do you load unique records into one target table and duplicate records into a different target table?
How do you convert single row from source into three rows into target?
How many types of sessions are there in informatica.please explain them?
What do you mean by filter transformation?
How to use procedural logic inside infromatica?
Reusable transformation and shortcut differences
Is it possible to revert a global repository to local one and why?
What is incremental aggregation?
Differences between version 7.x and 8.x.
