How to get flat files with no file structure as source and insert same data into table as target in IICS

Question

I wanted to get the flat files as source without any file structure specified using IICS(Informatica Intelligent cloud services). Flat files names can be anything, and structure also will change any. And also need to create table dynamically based on flat file and insert into table.

Answer 1

There's a number of options here. You can use a fully parameterized mapping niside a taskflow that will start on file listener, prepare the parameters and statements to be executed as part of the pre-SQL statement on your Target.

Inside the mapping you define Source and Target as parameterized - and that's briefly it!