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 |
On which interface you will be working as a developer?
How do you find the number of rows in a sequential file?
How do u convert the columns to rows in datastage?
Differentiate between Join, Merge and Lookup stage?
Can we use Round Robin for aggregator?is there any benefit underlying?
Explain the ChangeApply stage?
Source have 1000 records and it can have three nodes ok but i want how many records are executed on each node?
what is the unix script to run the job? Please mention commands which we use often?
When we will go for Data elements?
how do u reduce warnings
How one source columns or rows to be loaded in to two different tables?
Difference in the implementation of lookup and join stages,in joining two tables?