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 the main difference between sorragate key n primary key in one word
how do u convert date in 20-12-07 to dec-20-2007 or 20-dec- 2007 or 20-dec-07 in parallel
i have the source from Uk,north america how can i pass the data two tables based on the locations
how do u reduce warnings
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
we run a job in 4 nodes,i want to run same job on 8 nodes is it possible? job recompling is mandtory?why?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
Define project in datastage?
What is RCP
Hai..,This Kiran . how to immlement SCD's through sequential file.please explain briefly.if nt ask me i will explain ,what i know.
where we use config file as parameter ?
1.what is stagearea?what is stage variable? 2.this is my source source:id, name target:id, name 100, murty 100,madan we have three duplicate records for the id column,how can we getthe source record? 100,madan 100,saran