We can populate the sources metadata to target without using funnel stage using "Seqential File" Stage.
In Sequential file we have a property called "File" so first we give the file name and load the data.
Next time in the same sequential file right side we have a property "File" just click on that so it will ask another file name just give other file name ...do not load the data , in the same you can give how many files u have.
Finally you ran the job Automatically the data will be appended.
We can Run:
use a merge stage.
Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!