Answer / vinod upputuri

sysntax: orchadmin <delete/del/rm> <datasetname>

EX: orchadmin rm big.ds

Deleting the big.ds dataset.

Answer / dipanjan17

The dataset is written in internal format of datastage.
It stores data in the following form:

Descriptor File --->Data File
***Descriptor File --->Contains the pointer to the data file
***Data File--->Contains the actual data of the dataset
If we delete the descriptor file by using simple unix rm
command then the data file will still exist in the system.

Thus,Dataset is deleted by using an utility Orchadmin

Answer / subhash

Syntax:
Orchadmin delete | del | rm [options] dataset_Name1 …
sataset_NameN
EX:
a. Orchadmin delete EMP1.ds EMP2.ds EMP3.ds
b. Orchadmin rm EMP*.ds

Answer / shivaram

by using orch rmdataset.ds

Answer / rk

Using rm command we canm remove the dataset in unix

syntax:
rm xyz.ds

why do we need a datawarehouse when we have databases to store data?

1 Answers   L&T,

what is time dimension? and how to populate time demension

2 Answers   TCS,

What is the importance of the exception activity in datastage?

0 Answers  

if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?

5 Answers  

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

0 Answers   CTS,

source has 2 fields like COMPANY LOCATION IBM HYD TCS BAN IBM CHE HCL HYD TCS CHE IBM BAN HCL BAN HCL CHE LIKE THIS....... AND I WILL GET THE OUTPUT LIKE THIS.... Company loc count TCS HYD 3 BAN CHE IBM HYD 3 BAN CHE HCL HYD 3 BAN CHE PLZ SEND ME ANSWER FOR THIS QUESTION..........

3 Answers   Patni,

What is data partitioning?

0 Answers  

1.What is the flow of Transformer? 2.How can you do INDEX table in DataStage level?

0 Answers   EDS,

Hi guys, please design job for this, MY INPUT IS COMPANY,LOCATION IBM,CHENNAI IBM,HYDRABAD IBM,PUNE IBM,BANGLOORE TCS,CHENNAI TCS,MUMBAI TCS,BANGLOORE WIPRO,HYDRABAD WIPRO,CHENNAI HSBC,PUNE MY OUTPUT IS COMPANY,LOCATION,COUNT IBM,chennai,hydrabad,pune,banglore,4 TCS,chennai,mumbai,bangloore,3 WIPRO,hydrabad,chennai,2 HSBC,pune,1 Thanks

3 Answers   IBM,

Can we use Round Robin for aggregator?is there any benefit underlying?

3 Answers   TCS,

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

4 Answers   HSBC,

hi i am bhavani, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer

1 Answers   Polaris,