Example Job 2 for Sequential File

Requirement: Extracting EMP data from text file and loading into text file By using Sequential file Stage

Here Read method= specific file(s)

Reject Mode=Continue

Continue: Continue to simply discard any rejected rows;

Fail: Fail to stop if any row is rejected; Output to send rejected rows down a reject link.

SFB_1

here two records field delimiter is not properly ended  empno=300,400

Input sequential file_0 data:

SFB_2

Job:

SFB_3

Input sequential file_0 data Properties:

SFB_4

Output sequential_File_01 Properties:

SFB_5

Output data:

 

 

SFB_6

Related Posts Plugin for WordPress, Blogger...

Be the first to comment

Leave a Reply

Your email address will not be published.


*