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

HOW CAN WE SEE THE DATA IN DATASET?

Question Posted / vinod upputuri

12 Answers
58580 Views
IBM, TCS, I also Faced
E-Mail Answers

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

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1416

What are the main differences you have observed between 7.x and 8.x version of datastage?

1089

Is the value of staging variable stored temporarily or permanently?

999

What all the types of jobs you developed?

1181

What are some prerequisites for datastage?

1100

What is data partitioning?

1204

What can we do with datastage director?

1238

How do you import and export the datastage jobs?

1159

What is process model?

1979

What are the functionalities of link partitioner?

1022

Have you used Unstructured data?

1320

what is repositery?

1843

Explain usage analysis in datastage?

1168

Is it possible to query a hash file?

2012

What steps should be taken to improve Datastage jobs?

1073