IICS Informatica | Load Multiple Source Files Using Filelist or Indirect Method in IICS

in this video , we will lean how to load multiple files form same directory with some pattern and same structure using the filelist functionality , this is similar to indirect load in Powercenter . the Files should be mentioned in list file and then it loads the file data one by one in sequence .
#informatica #iics #informática #tutorial #etltesting #datawarehouse #sql

[@ETLSTATION]

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

[@suracharan7823]

You are doing good thing... Keep going bro we will support you 🎉💪

[@ETLSTATION]

Thank you support . keep watching

[@Raviiicslearn]

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.

[@ETLSTATION]

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

[@Raviiicslearn]

@@ETLSTATION thank you for the reply Roshan ! I think I got 70% what you saying 🙌

[@kulanagadeep9372]

Hi can you help me for parametrise the file list(dynamically it may be different every day) as object type

[@justomanuelzayaspinos6895]

I need it too

[@suracharan7823]

Hello bro, to load multiple files we need the columns should be same?

[@ETLSTATION]

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