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

Define meta stage?

0 Answers  

Hai..,in datastage how to explain project in interview?please explain any domain please.

1 Answers   Wipro,

explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

0 Answers   CGI,

how can find maximum salary by using Remove duplicate stage?

5 Answers   IBM,

which memory is used by lookup and join

5 Answers   IBM,




In a table 100 records are there after 50records job is aborted how can u insert all records in target table.

1 Answers   Cap Gemini,

what is the use of DSattchJob?DetachJob? where can we find it?

0 Answers   IBM,

Notification Activity

0 Answers   CTS,

diff between OLTP and OLAP? what TOP-DOWN and BOTTOM-UP Approach? which is best? what are Star Schema and Snow Flake Schema?

2 Answers   TCS,

How to enter a log in auditing table whenever a job get finished?

2 Answers   L&T,

how many types of sorting the data in data stage?

1 Answers   BoA, IBM,

Hi, Please tell me how to solve this scenario in datastage ? Here we have 3 columns in a table TEST CODE,ENTRY DATE and BATCH The table looks like CODE ENTRYDATE BATCH 100 100716 1 100 100716 1 100 100716 1 200 122517 2 200 122517 2 302 555555 8 302 555555 8 302 555555 8 We need to create a seqno on grouping these 3 columns. The result should be like this. CODE ENTRYDATE BATCH SEQNO 100 100716 1 1 100 100716 1 2 100 100716 1 3 200 122517 2 1 200 122517 2 2 302 555555 8 1 302 555555 8 2 302 555555 8 3

1 Answers   Alpharithm Technologies,

For more Data Stage Interview Questions Click Here
Categories