How to delete the data in dataset?types of deleting the data
in dataset?
Answers were Sorted based on User's Feedback
Answer / shilpasagar
We can delete the data in the dataset in 2 ways
1) Use Orchadmin command (orchadmin rm abc.ds)
2) Through Dataset Management option that is available in
the Director Client
| Is This Answer Correct ? | 16 Yes | 0 No |
Answer / venkat
We have two types of ways is there,
first one, we have to go dataset management in delete option
is there, and second one is via unix command
$orchadmin truncate[-f or -x] descriptor file name
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / arjun
if we want to delete the dataset file completely we have to delete the 3 dataset files
1.Descriptor file
2.Data file
3.Control File
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / chandrakant swain (hara)
suppose we have one file HSBC.ds ,having 5 fields or
columns,and
20 records,for deleting the all record
then
>$head -1 HSBC.ds > NEW_HSBC.ds
then rename the new file use mv command ,like this mannaer
>$mv NEW_HSBC.ds HSBC.ds
| Is This Answer Correct ? | 3 Yes | 18 No |
I have a few records just I want to store data in to targets cycling way how?
specify data stage strength?
Which algorithm you used for your hashfile?
what is main difference between change capture and change apply stages
AGGREGATOR default datatype
How can remove duplicates in a file using UNIX?
I have a input as: Col 1 1 2 2 3 I want 3 output as: Output1: 1 1 Output2: 2 2 Output3: 3 i.e. same duplicates should be in one target, other duplicate values should be in another target and so on.. Pls help
How do you register plug-ins?
What are the types of containers in datastage?
my source seq file have col1 1 2 3 4 5 6 7 8 9 i have 4 targets t1 t2 t3 t4 1 2 3 4 5 6 7 8 9 like this how we can get?
what is data mapping
What is exact difference between Parallel Jobs and server Jobs..