Home > Software > Data-Warehouse > DataStage
Interview Questions   Tutorials   Discussions   Programs   Discussion   

DataStage - How can we see the data in dataset?

asked mar September 20, 2014 06:31 AM  

How can we see the data in dataset?


1 Answers

answered By vishnoiprem   0  
We can view the data in the Dataset in UNIX by using orchadmin command.

orchadmin dump <datasetname>

  • 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
  • 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.

   add comment

Your answer

Join with account you already have



Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!