Load Different Data Files in Single Target Table

How to load the different data files in single target table using one data stage job? Files are having different name and data but target table in static.

Showing Answers 1 - 4 of 4 Answers

Lokeswar Perugu

  • Jun 18th, 2018

You can write a multi instance job. And parameterise the file name..by keeping table name constant..

  Was this answer useful?  Yes


  • Nov 17th, 2018

If the input file has same metadata and matching file name pattern, then
1. Set Sequential file Read method property to "File Pattern"
2. Provide File Pattern
Else, if different file name, then specify multiple File Read property with file name along with path.
This way you can read multiple files of same metadata. Provide other options in job to load the input files into target table.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions