Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett, rschirm, roy
-
getsatish_gk
- Participant
- Posts: 104
- Joined: Sat Dec 24, 2005 1:26 am
- Location: Bengaluru
Post
by getsatish_gk »
I want to truncate the oracle table and load it. but i could not find this option at oracle enterprise edition stage.
Does any one know who do truncate and load the oracle table?
Thanks in adv
Satish
-
martind
- Participant
- Posts: 12
- Joined: Thu Dec 18, 2003 4:41 am
- Location: Sydney
Post
by martind »
Set the Write Mode dropdown box to 'Truncate' in the Target on the Properties tab on the Oracle stage.
"I drink to make other people interesting"
George Jean Nathan
-
getsatish_gk
- Participant
- Posts: 104
- Joined: Sat Dec 24, 2005 1:26 am
- Location: Bengaluru
Post
by getsatish_gk »
I know this will only truncate the table. but what about data load after that?
but i want perform in one go.
-regards,
Satish
-
martind
- Participant
- Posts: 12
- Joined: Thu Dec 18, 2003 4:41 am
- Location: Sydney
Post
by martind »
This option will truncate and then append the new rows.
"I drink to make other people interesting"
George Jean Nathan
-
keshav0307
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
Post
by keshav0307 »
I know this will only truncate the table. but what about data load after that?
is it your assumption or it is written some where?