Hi ,
We have created a parallel job using Teradata connector stage as target ,sequential file as source stage .
We need to delete few records using presql before loading the data.
Delete from table where col1=orchestrate.col1 .
But job is aborting with error as "Object 'ORCHESTRATE' does not exist."
How do we use orchestrate in presql in teradata ?
How to use ORCHESTRATE in presql
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
Hi,
I came to understand that we cant use ORCHESTRATE in Pre/Post sql statement since it Pre/Post sql statement executes once for stage and Orchestate will execute for each and every row processed.
I came to understand that we cant use ORCHESTRATE in Pre/Post sql statement since it Pre/Post sql statement executes once for stage and Orchestate will execute for each and every row processed.
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
You can't leverage any "row data" in the pre or post areas, which is basically what you are trying to do. You'd either need to hard-code any values there or perhaps use job parameters to control what values get deleted.
So what kind of "few records" do you need to delete?
So what kind of "few records" do you need to delete?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 117
- Joined: Wed Feb 06, 2013 9:24 am
- Location: Chennai,TN, India