Six Stars

Tfileinput loads incomplete data

HI,

 

I have a table that has 8000 rows. When I output this table to Tfileoutput, it loads only 7500 rows.

 

is there any reason why it is loading only 7500 and missing 500 rows? is there a setting that I checked accidently. pls let me know.

1 ACCEPTED SOLUTION

Accepted Solutions
Forteen Stars TRF
Forteen Stars

Re: Tfileinput loads incomplete data

Connect the tInputFileDelimited to a tOutputFileDelimited using a Reject flow to get the rejected records (those not respecting the defined schema).


TRF
6 REPLIES
Nine Stars

Re: Tfileinput loads incomplete data

If possible please provide screen shot of job. Have you implemented any logic in job?

 

Regards,

Veeru Boppudi
Six Stars

Re: Tfileinput loads incomplete data

There is no logic build in tmap.

My input file has 8263 rows but it shows 7290 rows in output. See the screenshot. What could be a possible cause for it?

 

6.png

 

Twelve Stars

Re: Tfileinput loads incomplete data

yes.it could be possiable with bad data.can you get reject to log/file from tFileinput.

Manohar B
Forteen Stars TRF
Forteen Stars

Re: Tfileinput loads incomplete data

Connect the tInputFileDelimited to a tOutputFileDelimited using a Reject flow to get the rejected records (those not respecting the defined schema).


TRF
Twelve Stars

Re: Tfileinput loads incomplete data

@KanT,still do you have this issue?

Manohar B
Six Stars

Re: Tfileinput loads incomplete data

Hi, I was able to solve the issue.Thanks for checking!