how can we do null handling in sequential files
Answers were Sorted based on User's Feedback
Answer / kiran
go to target level of Seq_file ,click on Format Tab then
click on field format and select null field values=0.
| Is This Answer Correct ? | 19 Yes | 2 No |
Answer / venkat
go to target level of sequence file,click on format tab and then click field format select and put the value=''
| Is This Answer Correct ? | 0 Yes | 2 No |
what is factless fact table?
How many types of views are there in a datastage director?
specify data stage strength?
how can we join one oracle & flat files ?
how to cleansing data
j1,j2,j3 jobs r runing iwant to run j1,j3 after j2 how to do this using sequencer? 2)j1,j2,j3 jobs r runing iwant to run j1,j2,j3 how to do this?
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.
A job is having only 2 stages I/p dataset and target table.Job is taking very long time to load 50 million records.How to improve performance of this job.
Define ds designer?
I have a scenario like Deptno=10---->First record and last record Deptno=20---->First record and last record Deptno=30---->First record and last record I want those first and last records from each department in a single target. How to do this in DataStage, any one can assist me. Thanks in advance.
How many jobs in ur project? Explain any complex job u have done in ur project?
explain unit testing,systemtesting,integrated testing