Hi Guys,
How to create a table with some columns having default values in create table statement. Now how to create a job to load data using Teradata Enterprise in this table without having default columns in source data.
-Aim is to find out how DataStage behaves when we have created a Teradata table with default values and when we do not have those columns in source file.Please give me a suggetion in doing this.
Thanks in advance.
swathi.k
Teradata along with datastage
Moderators: chulett, rschirm, roy
it will ignore the values when you use the enterprise stage. this is because the work table which is created is based on the concept and not .this will drop any default values. Also note as the temp table is being created SET it will drop duplcated when you try to load it to TD. i think this is a bug in datastage. you can search the forum here. we have discussed this many times in detail.
p.s. also have a look into run time column propogation and an option in the enterprise stage. something like silently drop columns not in target.
Code: Select all
create SET TABLE orch_workxxx as select * from source with data
Code: Select all
a create multiset table work_orchxx as source with data
p.s. also have a look into run time column propogation and an option in the enterprise stage. something like silently drop columns not in target.
-
- Charter Member
- Posts: 193
- Joined: Tue Sep 05, 2006 8:01 pm
- Location: Australia
Re: Teradata along with datastage
er..How DataStage behaves is dependent on how you make it behaveswathik wrote:Hi Guys,
How to create a table with some columns having default values in create table statement. Now how to create a job to load data using Teradata Enterprise in this table without having default columns in source data.
-Aim is to find out how DataStage behaves when we have created a Teradata table with default values and when we do not have those columns in source file.Please give me a suggetion in doing this.
Thanks in advance.
swathi.k
it's entirely up to the developer to tell DS what to do.
hamzaqk,
Just wanted to clarify on the temporary table creation mechanism.
Will it not be
create SET TABLE orch_workxxx as select * from source with NO data
Instead of
create SET TABLE orch_workxxx as select * from source with data
Thanks
Just wanted to clarify on the temporary table creation mechanism.
Will it not be
create SET TABLE orch_workxxx as select * from source with NO data
Instead of
create SET TABLE orch_workxxx as select * from source with data
Thanks
hamzaqk wrote:it will ignore the values when you use the enterprise stage. this is because the work table which is created is based on the conceptand not .Code: Select all
create SET TABLE orch_workxxx as select * from source with data
this will drop any default values. Also note as the temp table is being created SET it will drop duplcated when you try to load it to TD. i think this is a bug in datastage. you can search the forum here. we have discussed this many times in detail.Code: Select all
a create multiset table work_orchxx as source with data
p.s. also have a look into run time column propogation and an option in the enterprise stage. something like silently drop columns not in target.