How can we do null handling in sequential files

Answers were Sorted based on User's Feedback



How can we do null handling in sequential files..

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

How can we do null handling in sequential files..

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 can we do null handling in sequential files..

Answer / hari

YA UR EXACTLY RIGHT PHANI.

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Data Stage Interview Questions

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?

4 Answers   L&T,


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

1 Answers   HCL,


How do you import and export the datastage jobs?

0 Answers  


how to find out number of records imported into source file?

1 Answers  


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?

0 Answers   Wipro,


In merge stage can we update the values?

3 Answers   TCS,


on how many columns we can perform aggregation in the Aggregator stage?

3 Answers   Reliance,


I have a source like file it have Number of records and i want to load without first and last records in target?Datastage?

4 Answers   CSC,


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?

0 Answers   Wipro,


what is the difference between == and eq in UNIX shell scripting?

0 Answers   CTS,


What is exact difference between Parallel Jobs and server Jobs..

8 Answers   DELL, IBM,


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

0 Answers  


Categories