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
CHANGE CAPTURE
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
How to read the length of word in unix?
Why fact table is in normal form?
Differentiate between validated and Compiled in the Datastage?
What is the difference between account and directory options ?
What steps should be taken to improve Datastage jobs?
What are the functionalities of link partitioner?
Explain how a source file is populated?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
Difference between sequential file and data set?
How to find value from a column in a dataset?
Whats difference betweeen operational data stage (ods) and data warehouse?