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.
Answer Posted / subhash
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 |
Post New Answer View All Answers
What is the difference between Datastage 7.5 and 7.0?
On which interface you will be working as a developer?
How do you import and export the datastage jobs?
What is a merge in datastage?
what is use of SDR function?
Define meta stage?
How many types of hash files are there?
What is the flow of loading data into fact & dimensional tables?
How to reverse the string using unix?
What is datastage engine?
What are the various kinds of containers available in datastage?
What are the different common services in datastage?
What are the various kinds of the hash file?
What is a datastage job?
What is a ds designer?