How can we do null handling in sequential files?
Answers were Sorted based on User's Feedback
Answer / krishnabadimala@gmail.com
we can do null handling in sequential file by using null
field value option.which is available in format tab then we
have to et null field value=<what do u want>
| Is This Answer Correct ? | 16 Yes | 0 No |
Answer / dheeraj
we can do null handling in sequential file by using null
field value option.which is available in format tab.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / naga
While importing the data we can specifie nullable 'yes' in define tab.
or
In format tab we can specifie the Final delimeter as 'null'.
| Is This Answer Correct ? | 5 Yes | 8 No |
what is set mapping in datastage??
What are the processing stages?
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.
What is the purpose of pivot stage?
How to generate surrogate key without using surrogate key stage?
tell me abt Datastage trigger?
I am having two tables called MASTER and DETAIL. I want to insert records to both tables. But one condition is that whenever the insert for MASTER table is success then only the records will inserted into the DETAIL table, otherwise abort the job. How can u design this job?
What is RCP?
What r the existing server jobs in parallalism?
i have data like sam ram sam raj ram I want two targets trgt1 ram sam trgt2 raj how can i do this in datastage?
What is confirmed Dimension? what is Factless Fact? give one example? What are Additive, Semi-Additive Facts?
Notification Activity