Answer Posted / metilda
We cannot see the data in the Data Set (.ds files) through
Unix, Editplus etc.
1. But we can view the data by connecting a Peek stage to
the Data Set stage in a job. Go to Director--> job name ---
> Peek stage (view .ds file data) or
2. Connect Sequential File Stage as the target stage to the
Data Set stage. In the Sequential File Stage-->Input Tab--
>Properties--> Give the Target file path. For Eg:
(/local/data1/edw/temp/DataSetOp.txt) and run the job. the
new text file gets loaded with data from the .ds file. Thus
data will be in a readable format in the text file.
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
Describe link sort?
Explain the importance of surrogate key in data warehousing?
How many types of hash files are there?
What are constraints and derivations?
sed,awk,head
Can you explain how could anyone drop the index before loading the data in target in datastage?
What is the difference between passive stage and active stage?
On which Dimension Table you implemented SCD Type in your Project
what is 'reconsideration error' and how can i respond to this error and how to debug this
What are the main differences you have observed between 7.x and 8.x version of datastage?
What are the enhancements made in datastage 7.5 compare with 7.0?
How many types of stage?
How rejected rows are managed in datastage?
What is the use of datastage director?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4