One flatefile it contains some data but i want to dont want to load first and l

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?

Question Posted / rv

2 Answers
5751 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

One flatefile it contains some data but i want to dont want to load first and last record ..how it ..

Answer / 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

One flatefile it contains some data but i want to dont want to load first and last record ..how it ..

Answer / purushothaman

put one expression after the source qualifer
and type this code

for example take this record
HDR20008
....
TRL2000800020

output variable name = IFF(SUBSTR(columnname ,1,3)
='HDR','Y','N')
Similarly put for trailer record condition in the
expression

after this expression put the one filter like this
output variable name ='Y'

cheers!!!!!!!!!!!!!!!!!

Is This Answer Correct ?

0 Yes

7 No

Post New Answer