Hi Friends Thank you for watching my video . Please subscribe to my channel like it and share it with your friends . also comment if you get any doubt on video , i will try to answer your doubt
So beautiful explanation , so elegantly presented each video , just sounding like a WOW 👏🙏. @roshan , i've a scenario like in a filelist we have 5 files , after loading 1& 2 files for some reason job got failed , when i restart i should not read from the file 1, it should start from file 3 - How would be the restartbility approach in this case ? Also It would be a great video to cover with more other restartability scenarios on various use cases.
you can write filename in one target file and use this as lookup , if filename exist in this lookup file then filter those records if file name not there then load it . utilize the fileprocessed properties in source and write in one target file to use as lookup
yes . column name need not to , but values shoudd be same otherwise why u will load in same target buddy if they r not similar values . like one file can have emp_name and other can have employee_name both will go to target column emp_nm
Hi Friends Thank you for watching my video . Please subscribe to my channel like it and share it with your friends .
also comment if you get any doubt on video , i will try to answer your doubt
You are doing good thing... Keep going bro we will support you 🎉💪
Thank you support . keep watching
So beautiful explanation , so elegantly presented each video , just sounding like a WOW 👏🙏. @roshan , i've a scenario like in a filelist we have 5 files , after loading 1& 2 files for some reason job got failed , when i restart i should not read from the file 1, it should start from file 3 - How would be the restartbility approach in this case ? Also It would be a great video to cover with more other restartability scenarios on various use cases.
you can write filename in one target file and use this as lookup , if filename exist in this lookup file then filter those records if file name not there then load it . utilize the fileprocessed properties in source and write in one target file to use as lookup
@@ETLSTATION thank you for the reply Roshan ! I think I got 70% what you saying 🙌
Hello bro, to load multiple files we need the columns should be same?
yes . column name need not to , but values shoudd be same otherwise why u will load in same target buddy if they r not similar values . like one file can have emp_name and other can have employee_name both will go to target column emp_nm
Hi can you help me for parametrise the file list(dynamically it may be different every day) as object type
I need it too