Sequential File - How to get output from sequential file and database?

How to get the following output:

Eno,Address,ContactNo
1, Address 1, 123456789

from a sequence file with data as follows:

Eno,Address
1, Address 1

and a table in database with record as:

Eno,ContactNo
1,123456789
at

1 comment:

  1. Error and Fix TravelJanuary 31, 2011 at 11:00 PM

    To get the required output, sequential file stage can be joined with the relevant database native stage. Do remember to sort the key columns before the join stage and map the required fields in the output tab in join stage. Usage of the join stage depends on the number of records in seq. file as well as in database table. If records in any of these sources is fairly small then lookup stage can also be used. This will make the overall job more performant.

    ReplyDelete

Subscribe to: Post Comments (Atom)