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

Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result as values before the delimiter should come under the column ITEM_CODE and values after the delimiter should come under the column LOC_CODE.. But some datas like "SCH-AS-1010", for this, "SCHAS" should come under the column ITEM_CODE and 1010 should come under the column LOC_CODE.. Pls help me..

1 Answers  

How you Remove the Dataset in Unix?

5 Answers  

What is quality stage?

0 Answers  

why we use parameters instead of hard code in datastage

4 Answers   HCL,

what is advantages of snowflake when it is used?

3 Answers   IBM,

in source is like seq file in date column have dd-mm-yy dddd-mmmm-yyyy mm-dd-yy yy-dd-mm yy-mm-dd i want to display only yy-dd-mm date formats only in tgt?

2 Answers   Wipro,

i have 3 diffrent tables. 1) US rate data 2)CANADA rate data and 3)MEXICO rate data. All 3 tables have 6 collumns each. 4 collumns are commun to all tables and 2 are diffrent. Now at target i want single table say Country rate which will have (4+2+2+2+1 flag) 11 collumns. I will add a flag collumn which will indicate country and will put nullable collumns which are not common to other. How i can implement this in datastage?

1 Answers   ABC,

What is a merge in datastage?

0 Answers  

What is a range lookup?

2 Answers   IBM,

What are routines in datastage?

0 Answers  

Demonstrate experience in maintaining quality process standards?

0 Answers   iGate,

WHAT IS FORCE COMPILE?

3 Answers   FIS, HCL, Polaris,