HOW CAN WE SEE THE DATA IN DATASET?

Answer Posted / vinod upputuri

Gentlemen, We can view the data in dataset in unix by using
orchadmin command
syntax: orchadmin dump <descriptor.ds>

copy the contents of dataset into flat file:

Syntax: orchadmin copy <descriptor_file.ds> <flatfile>

count of records:

Syntax: orchadmin copy <descriptor_file.ds> <flatfile> | wc -l

Is This Answer Correct ?    6 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

4572


Can you define merge?

670


how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

2739


What is a ds designer?

645


What are routines in datastage?

780






What is active and passive stage?

887


What a datastage macro?

641


What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

1905


Can you implement SCD2 using join, transformer and funnel stage?

1095


How and where you used hash file?

661


How complex jobs are implemented in datstage to improve performance?

604


what is the difference between == and eq in UNIX shell scripting?

981


What are stage variables?

641


What are the types of jobs we have in datastage?

678


What is meta stage?

582