|
|
|
Forum Newbie
Group: Forum Members
Last Login: 4/29/2009 7:46:34 AM
Posts: 7,
Visits: 9
|
|
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
cnew
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 11/5/2009 4:40:02 PM
Posts: 717,
Visits: 466
|
|
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
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 4/29/2009 7:46:34 AM
Posts: 7,
Visits: 9
|
|
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....
cnew
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 4/29/2009 7:46:34 AM
Posts: 7,
Visits: 9
|
|
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
cnew
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 11/1/2009 1:22:16 PM
Posts: 15,
Visits: 77
|
|
Hi,
use union transformation in informatica and load the data in to target using fastload external loader.
Regards,
kiran
|
|
|
|