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 are some prerequisites for datastage?
Can you define merge?
Differentiate between data file and descriptor file?
What is the purpose of interprocessor stage in server jobs?
Explain usage analysis in datastage?
What is the difference between orabulk and bcp stages?
explain about citrix scheduling tool in datastage
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
why do u need the IOS upgradation in a FC switch
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
describe the Steps to confiure a Qlogic switch
What is difference between join, merge and lookup stage?
Can you filter data in hashed file?
How to reverse the string using SQL?