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
What is the difference between operational data stage (ods) and data warehouse?
client know skid info?
Explain Quality stage?
How one source columns or rows to be loaded in to two different tables?
Have you used Unstructured data?
how many rows sorted in sort stage by default in server jobs
options available in sequence job to run,validate?
Describe routines in datastage? Enlist various types of routines.
What is apt_config in datastage?
What is the difference between in process and inter process?
How to Remove Duplicate using SQL?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
what are the devoleper roles in real time? plz tell i am new to datastage....
What are the functionalities of link partitioner and link collector?
Why fact table is in normal form?