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 are the functionalities of link partitioner and link collector?
What is orabulk stage?
How many types of hash files are there?
If you want to use a same piece of code in different jobs, how will you achieve this?
Explain the importance of surrogate key in data warehousing?
1.How do u handle NULL in sequential stage. 2.Difference between switch stage and filter stage.
What is a merge in datastage?
How and where you used hash file?
1)Source file contains one record, I want 100 records in target file.
What is the roundrobin collector?
Difference between sequential file and data set?
Define ds designer?