File List Concept in IICS | Informatica IICS Tutorial | How to automate IICS using scripts?

[@NICITACADEMY]

*Self-Paced Courses and Interview Questions Links:* courses.nicitacademy.com/courses *Informatica IICS/IDMC - CDI - Self-Paced Training:* courses.nicitacademy.com/courses/Informatica-IICSIDMC---Self-Paced-Training-64d4aad1e4b014e8d478f891-64d4aad1e4b014e8d478f891 *Informatica IICS - Cloud Application Integration - CAI* courses.nicitacademy.com/courses/Informatica-IICS---Cloud-Application-Integration---CAI-64fea495e4b05857d8384718-64fea495e4b05857d8384718 *Informatica PowerCenter - Self-Paced Training:* courses.nicitacademy.com/courses/Informatica-PowerCenter---Self-Paced-Training-64f0c8cbe4b09fcb108b8003-64f0c8cbe4b09fcb108b8003 *Oracle PLSQL - Self-Paced Training:* courses.nicitacademy.com/courses/Oracle-PLSQL---Self-Paced-Training-64dd43b2e4b0d139b4e090a7-64dd43b2e4b0d139b4e090a7 *IICS CDI - 100 Interview Questions and Answers* courses.nicitacademy.com/products/650788efc7dca83c054f6965?dgps_u=c&dgps_s=ucpd&dgps_t=cp_u&dgps_uid=64d47cdbe4b049d09c002e22 *IICS CAI - Top 60 Interview Questions and Answers* courses.nicitacademy.com/products/650e0208ec6a493964ffbe4b?dgps_u=c&dgps_s=ucpd&dgps_t=cp_u&dgps_uid=64d47cdbe4b049d09c002e22

[@velusamythangavel6892]

Hi Chandra I attended your IICS training last May 2023 batch, and I got a job in IICS. Thank you.

[@NICITACADEMY]

Thanks for your wonderful feedback, Please continue to watch my channel to learn more. Contact me for more details @[phone] 🌕 wa.link/m4lat0 *Self-Paced Courses and Interview Questions Links:* courses.nicitacademy.com/courses Thanks, Chandra

[@DhivyaReddy-n4i]

Hi Chandra Garu, First and foremost, I would like to express my gratitude for your Informatica PowerCenter videos. I was able to learn everything I needed to know about Informatica through your informative videos. I have recently landed a job in the US and my company is now transitioning to IICS. I am interested in taking live training for IICS. May I know how to enroll and contact you for further details? Thank you for your helpful videos. I believe they will continue to benefit individuals like myself.

[@NICITACADEMY]

Thanks for your wonderful feedback, Please continue to watch my channel to learn more. Contact me for more details @[phone] 🌕 wa.link/m4lat0 *Self-Paced Courses and Interview Questions Links:* courses.nicitacademy.com/courses Thanks, Chandra

[@chandrakanth6528]

Outstanding video👏

[@NICITACADEMY]

Thank you! Cheers!

[@VenkatReddy-zo3kx]

Sir in this case we have less files so we are creating a list file. In case if we have more files means how can we achieve in that scenario

[@NICITACADEMY]

Please watch the fully, I explained how to automate with scripts in case of more files.

[@aravindkumar9476]

Hii sir... I have one doubt that can we execute unix commands in trail version.. will it work??or in licensed version only unix commamds will work

[@NICITACADEMY]

If the secure agent installed on Unix, then you can use Unix command.

[@MrSwargo]

Dear Sir, Very useful content.Thanks. Is it possible to read multiple xlsx files (not csv files) through indirect file load like file list or command in iics? If so kindly let me know. If xlsx files not possible to load the please let me how to convert all excel files to csv files though iics. Thanks in advance

[@NICITACADEMY]

Yes, you can. if the structure of the file is same, we can mention all the file names in the source file.

[@MrSwargo]

Thanks for your prompt response. Multiple excels read as file list connector with all excels are in same structure, still iics not able to read the data, it's showing invalid character. While opening each excel sheets with notepad++ data are showing in ascii code. Is there a way first I convert all the excel files in csv files and then load as file list? Any help would be very much appreciated.

[@kalyand3959]

If the flat file has different delimiters...can we execute in same way or we need to change the delimiters??

[@NICITACADEMY]

A flat file should have the same delimiter.

[@anilanche5753]

Hi sir Can you provide shell script for same to combine all file ls informations in indirect file.