Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 1 Answers
- 5958 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
Define Data Stage?
What are the different layers in the information server architecture?
What are the different type of jobs in datastage?
What is the project in datastage?
What are the functionalities of link partitioner?
How one source columns or rows to be loaded in to two different tables?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
CHANGE CAPTURE
what is use of SDR function?
What is the sortmerge collector?
What are transforms and what is the differenece between routines and transforms?
How to reverse the string using unix?
what is repositery?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
