Hi All,
Can we write user-defined queries in a teradata stage when teradata stage is acting as destination.
I dint find any option as such, but will it be possible if we install any plug-ins?
Thanks and regards,
ssunda
user-defined sql queries-teradata stage is destination
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 560
- Joined: Wed Jul 13, 2005 5:36 am
- Location: Ohio
by default-it is auto-generated query
Hi KrazyKoolRohit,
In the teradata stage, we have options insert,append etc.
But by default, the query is auto-generated.
If I want the following operation to be done,
insert into emp_table(empno_dim,empname,email) values (empnoseq.nextval,empname,email).
empnoseq is a sequencer, how can we mention that sql query in teradata stage. Thats what I meant , when I said user-defined sql query.
Any info regarding this would be helpful
regards,
ssunda
In the teradata stage, we have options insert,append etc.
But by default, the query is auto-generated.
If I want the following operation to be done,
insert into emp_table(empno_dim,empname,email) values (empnoseq.nextval,empname,email).
empnoseq is a sequencer, how can we mention that sql query in teradata stage. Thats what I meant , when I said user-defined sql query.
Any info regarding this would be helpful
regards,
ssunda
-
- Charter Member
- Posts: 560
- Joined: Wed Jul 13, 2005 5:36 am
- Location: Ohio
-
- Premium Member
- Posts: 209
- Joined: Fri Jan 09, 2004 1:14 pm
- Location: Toronto, Canada
- Contact:
Re: user-defined sql queries-teradata stage is destination
Hi ssunda,ssunda6 wrote:Can we write user-defined queries in a teradata stage when teradata stage is acting as destination.
What type of TD stage are you using?
If it's the enterprise stage, you can specify on your 'Properties' tab, in the 'Connection' branch a 'DB Options Mode' property. Set this to 'User-defined' and you can enter a user defined SQL.
If it's the MultiLoad stage, on the 'MultiLoad' tab change 'Load Type' to 'Custom'. This will enable the 'Custom' tab on the 'Script' tab. You can put custom SQL in the 'Custom Script', press the 'Generate Sample' button to get a sample. View the help for this screen for more info.
All of this assumes, of course, that you are using the Parallel edition as your profile suggests.
Rob W
Rob Wierdsma
Toronto, Canada
bartonbishop.com
Toronto, Canada
bartonbishop.com
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia