1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

in sequtial file 2 columns avaliable, i want only one column
load the target. for this we can do by modify and copy
stage. But here when using modify stage (in property drop
column1) until it is ok. if target is data set How to view
the data. with out using data management. what is the reason
for this. if any body know this answer plz tel me.

thanks.

Question Posted / suneel


in sequtial file 2 columns avaliable, i want only one column load the target. for this we can do b..

Answer / subhash

We can not view directly, because it stores the data in the datastage internal format.
1. After running the job, directly open the DataSet and click on 'view data'
2. we can view data using 'DataSet management' which is available in Ds Director, tool menu.
3. we can view data using 'ORCHADMIN' unix command.

a. Orchadmin dump EMP.ds
b. Orchadmin dump EMP.ds 2>/dev/null ---> redirecting to output.
c. Orchadmin dump EMP.ds 2>/dev/null >SampleFile.txt --> redirecting output to file.

Is This Answer Correct ?    6 Yes 0 No

Post New Answer

More Data Stage Interview Questions

My source having following data as below, AB1 Aim2 Abnv5 1An8bx and my question is i need the Datastage job the following as in my target 000AB1 00Aim2 0Abnv5 1An8bx Please help me to achive this.

6 Answers   Wipro,

If the job aborted in a sequencer, how can we start that from the previews successful job.

1 Answers   SLK Software,

I have file with empid,empname and I want to load these two fields along with sal in my target 1)salary must be same for all the records 2)I want pass the salary at run time

7 Answers   TCS,

how to remove duplicates in transformer stage by using stage variables?one example?

6 Answers   Syntel, TCS,

how to create document in datastage?

1 Answers   Cap Gemini,




How can we perform 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

1 Answers   Infosys, TCS,

what is hash file

2 Answers   CTS, IBM,

1.what is materialized data? 2.how to view the materialized data?

0 Answers   HCL, IBM,

Explain the importance of surrogate key in data warehousing?

0 Answers  

table a contains 5 columns and table b contains 5 columns how can i get 10 columns at target?

9 Answers  

What is the difference between the local container and shared container?

0 Answers  

What is the difference between Link collector and Funnel Stages?

1 Answers  

For more Data Stage Interview Questions Click Here
Categories