in sequtial file 2 columns avaliable, i want only one column
load the target. for this we can do by modify and copy
stage. But here when using modify stage (in property drop
column1) until it is ok. if target is data set How to view
the data. with out using data management. what is the reason
for this. if any body know this answer plz tel me.
thanks.
We can not view directly, because it stores the data in the datastage internal format.
1. After running the job, directly open the DataSet and click on 'view data'
2. we can view data using 'DataSet management' which is available in Ds Director, tool menu.
3. we can view data using 'ORCHADMIN' unix command.
a. Orchadmin dump EMP.ds
b. Orchadmin dump EMP.ds 2>/dev/null ---> redirecting to output.
c. Orchadmin dump EMP.ds 2>/dev/null >SampleFile.txt --> redirecting output to file.
| Is This Answer Correct ? | 6 Yes | 0 No |
How do you remove duplicate values in datastage?
what is the new version in Datastage ? what is the diff b/t New vesion & 7.5 version?
Why fact table is in normal form?
What is the difference between orabulk and bcp stages?
What all are the different way to run a job?
How to remove duplicates in transformer stage? in parallel mode
Describe the architecture of datastage?
wt is the diff b/w odbc and oracle stage
What steps should be taken to improve Datastage jobs?
project Steps,hits, Project level HArd things,Solved methods?
what is the difference between INROWNUM AND OUTROWNUM IN DATASTAGE SERVER EDITION?
Differentiate between datastage and datastage tx?