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 |
In my previous project we get data from mainframe and load it into datastage DB2 tables.Sometimes we get data as flat file or a mainframe tables itself directly we fetch the data.Is this a migration project?
What are data elements?
what is usage of datastage with materialized views
how to implement scd2 in datastage 7.5 with lookup stage
What are the partitioning techniques available in link partitioner?
I have a few records just I want to store data in to targets cycling way how?
1) In a dataset how to delete a single row? 2) i have 50 rows , i want to display 5-7 records only? How to write the sql query? 3)i have 40 rows,i want to display last row? write sql query?
If you want to use a same piece of code in different jobs, how will you achieve this?
how can we generate row values like 1 1 1 2 2 2 3 3 3 using col generator plz let me know
1.how to generate even numbers in surrogate or tranformar stage ? 2. how many ways to remove duplicate values?
What are the features of datastage flow designer?
Difference between in process and inter process?