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
On which interface you will be working as a developer?
Name the third party tools that can be used in datastage?
How many types of views are there in a datastage director?
What is a datastage job?
What are the features of datastage flow designer?
Explain ibm infosphere information server and highlight its main features?
What is the difference between Datastage 7.5 and 7.0?
How do you import and export data into datastage?
What is the purpose of pivot stage?
what is the use of skid in reporting?
What a datastage macro?
Define repository tables in datastage?
I have a few records just I want to store data in to targets cycling way how?
How you Implemented SCD Type 1 & Type 2 in your project?
Define Data Stage?