How can we do null handling in sequential files
Answers were Sorted based on User's Feedback
Answer / phani kumar
Sequential file doesn't handle nulls. If the file contains
nulls, then it gives records while reading the file by using
sequential stage,only records which are not having nulls.
In order to handle nulls, there is a option available in
seq.file as NULL TO VALUE. Here, we can give any value for
replacing of Nulls.
Then, DS Engine will consider those symbols are nulls while
reading the data from sequential file.
Thanks and regards,
Phani kumar
Is This Answer Correct ? | 5 Yes | 2 No |
Answer / kak
In sequential file we have one property null to value or
null to zero using that we can handle the nulls.
Is This Answer Correct ? | 4 Yes | 2 No |
what are the types of nodes
Hi guys, please design job for this, MY INPUT IS COMPANY,LOCATION IBM,CHENNAI IBM,HYDRABAD IBM,PUNE IBM,BANGLOORE TCS,CHENNAI TCS,MUMBAI TCS,BANGLOORE WIPRO,HYDRABAD WIPRO,CHENNAI HSBC,PUNE MY OUTPUT IS COMPANY,LOCATION,COUNT IBM,chennai,hydrabad,pune,banglore,4 TCS,chennai,mumbai,bangloore,3 WIPRO,hydrabad,chennai,2 HSBC,pune,1 Thanks
What is mapping?
What r the existing server jobs in parallalism?
How to remove duplicates in transformer stage? in parallel mode
What is APT_DUMP_SCORE?
What are the some differences between 7.x and 8.x version of datastage?
what is the diff b/w switch and filter stage in datastage
How do u call shellscript/Batch file from DS?
Describe stream connector?
What all the types of jobs you developed?
What is the difference between Datastage 7.5 and 7.0?