HOW CAN WE SEE THE DATA IN DATASET?

Answer Posted / vinod upputuri

Gentlemen, We can view the data in the Dataset in UNIX by
using orchadmin command.

syntax: orchadmin dump <datasetname>

we can also copy the content to flat file using copy command.

orchadmin copy <datasetname> <flat_fileName>

In order to count rows in Dataset:

orchadmin copy <datasetname> <flatfile> | wc -l

Is This Answer Correct ?    2 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you remove duplicate values in datastage?

632


Triggers,VIEW,Procedures

802


What is the difference between operational data stage (ods) and data warehouse?

675


Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

1620


What is the precedence of stage variables,derivations, and constraints?

601






Explain usage analysis in datastage?

656


What are iconv and oconv?

777


What are stage variables?

638


Differentiate between datastage and datastage tx?

599


What is the use of hoursfromtime() function in transformer stage in datastage?

585


What are the different kinds of views available in a datastage director?

606


What is the difference between account and directory options ?

623


Where the datastage stored his repository?

618


What could be a data source system?

580


How to perform incremental load in datastage?

670