Multiple flat files loading into singletable using fload

Tools
Enthusiast

Multiple flat files loading into singletable using fload

Hi!
I have multiple falt files say 3 flat files having same structure and these 3 files needs to be loaded into one tabe using fload. i tied but once i loaded the first table then second table i cannot load as the table needs to be empty for fload.
Appreciate quick response if anyone can tell the script.????

Thanks in advance
4 REPLIES
Senior Apprentice

Re: Multiple flat files loading into singletable using fload

Remove the END LOADING in your first script.
Copy the script and change the filename to the second file.
Copy the script and change the filename to the third file, this time include END LOADING.

Run those scripts one after the other.

Dieter
Enthusiast

Re: Multiple flat files loading into singletable using fload

Thanks, it works but i want to do it at single operation...say 8 files then i dont want to run the utility for 8 times instead at one command it should load the 8 files data into table.. early help is appreciated....
Enthusiast

Re: Multiple flat files loading into singletable using fload

Hi!
I am using informtica 7.1.3 and the database is teradata 6.1.
now i want to load the flat file data into teradata using fload script. how to configure my workflow settings suing teradata fload external loader.

Thanks in advance
Enthusiast

Re: Multiple flat files loading into singletable using fload

Hi,

use union transformation in informatica and load the data in to target using fastload external loader.

Regards,
kiran