Can We use filler concept in FastLoad

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

Can We use filler concept in FastLoad

Rate Topic

Display Mode

Topic Options

Author

Message

kiran_terydata

Posted 9/14/2009 1:09:22 AM

Forum Newbie

Group: Forum Members
Last Login: 10/20/2009 1:44:00 AM
Posts: 7, Visits: 10

Hi Friends

Can we load filler concept in fastload, i.e., i want to select only specified columns in the fastload,
can i do the job?

Thanks

KIRAN KUMAR

KIRAN

Post #16817

babak

Posted 9/14/2009 1:55:26 PM

Forum Newbie

Group: Forum Members
Last Login: 9/18/2009 4:36:17 AM
Posts: 5, Visits: 11

Yes,
Just declare the unwanted fields as DUMMYnnn with the correct datatype, and don't use it whithin the insert caommand,
In this case, you must use INSERT Into )

Post #16823

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 6:10pm