How you Remove the Dataset in Unix?
Answers were Sorted based on User's Feedback
sysntax: orchadmin <delete/del/rm> <datasetname>
EX: orchadmin rm big.ds
Deleting the big.ds dataset.
| Is This Answer Correct ? | 7 Yes | 0 No |
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
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / rk
Using rm command we canm remove the dataset in unix
syntax:
rm xyz.ds
| Is This Answer Correct ? | 0 Yes | 10 No |
My input has a unique column-id with the values 10,20,30.....how can i get first record in one o/p file,last record in another o/p file and rest of the records in 3rd o/p file?
What are the third party tools you used in your project?
Emp login_timestamp Logout_timestamp A,2019-02-01 02:24:15,2019-02-01 04:59:42 B,2019-03-29 14:43:30,2019-03-29 20:22:00 ABC,2019-03-29 12:43:00,2019-03-29 23:22:59 In the above calculate the duration of hours spent in office for each emp in datastage.
How do u view log file for a particular job?
DataStage Scenario based Interview Questions
deptno wise to find max and min,and sum of rows and in target to company wise maximum
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
What is the project in datastage?
How to initialize environment variables?
Hi I have scenario like this s/r table T/r table ename,sal empno,ename,sal vijay,2000 1 , vijay, 2000 kumar,3000 2 ,kumar , 3000 ravi ,4000 3 ,ravi , 4000 How can i get target table like that without using Transformer stage?
IS FILE SET CAN SUPPORT I/P AND O/P LINK AT A TIME?
How to convert alpha Numeric values to alpha using functions?