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 |
HOW WILL YOU IMPLEMENT SURROGATE KEY IN SCD BY USING SURR_KEY GENERATOR,THE VALUE OF S_KEY SHOULD NOT REPEAT EVEN IF THE JOB IS COMPILED REPEATEDELY?
input Name Salay Sam 10 Sam 30 Sam 20 Ram 40 Ram 50 Output should be Name Salary Count Sam 10 3 Ram 40 2 get min salary and count of name . OutPut 2 Name Seq Sam 1 Sam 2 Sam 3 Ram 1 Ram 2
How do you import and export the datastage jobs?
how to find out number of records imported into source file?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
In merge stage can we update the values?
on how many columns we can perform aggregation in the Aggregator stage?
I have a source like file it have Number of records and i want to load without first and last records in target?Datastage?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
what is the difference between == and eq in UNIX shell scripting?
What is exact difference between Parallel Jobs and server Jobs..
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees