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 |
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.
What is Cleanup Resources and when do you use it?
hi, 1)totally how many jobs created in ur project 2)what is ur datamart size & Dwh size 3)How secure ur project 4)could u plz tell be about testing process after complete the job will run sucessfully or not in Datastage
How to read multiple files at different directories using a single Sequential File stage in DS Enterprise Edition
What is container and then types?
What is size of a transaction and an array means in a datastage?
how can we create a Sorrogate key in transformer stage? I want it in parallel mode
what is mapping lookup
What is the difference between datastage and informatica?
Unix command to view the data in a dataset
What is the difference between account and directory options ?
i hav source like this . deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like this target1 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformer