How to delete the data in dataset?types of deleting the data
in dataset?

Answers were Sorted based on User's Feedback



How to delete the data in dataset?types of deleting the data in dataset?..

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

How to delete the data in dataset?types of deleting the data in dataset?..

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

How to delete the data in dataset?types of deleting the data in dataset?..

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

How to delete the data in dataset?types of deleting the data in dataset?..

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

Post New Answer

More Data Stage Interview Questions

What are the unit test cases you used in your project?

1 Answers   CSC, HY,


hi, how would i run job1 then job 3 , then job2 in a sequence of job1 ,job2,job3. Thanks sunitha

6 Answers   CTS,


A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

0 Answers  


how to call routines in stages?

3 Answers   ME,


Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

0 Answers   ABC, TCS,


What are the functionalities of link partitioner and link collector?

0 Answers  


What is quality stage?

0 Answers  


How do u set a default value to a column if the column value is NULL?

7 Answers   HP,


How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?

0 Answers   Wipro,


IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?

3 Answers   Infosys,


Where do you see different stages in the designer?

0 Answers  


What is a merge in datastage?

0 Answers  


Categories