1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

How can we do null handling in sequential files

Question Posted / tallamaheshgoud

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

What is quality stage?

0 Answers  

convert yyyy mm dd to dd mm yyyy?

4 Answers  

What is PX?

2 Answers   IBM,

Explain the functionality of your current project?

1 Answers   IBM, Miles Software,

What are the various kinds of the hash file?

0 Answers  




how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

0 Answers  

difference between server shared container and parallel shared container

6 Answers   CTS,

if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

0 Answers   IBM,

How to transfer file from one system to another system in UNIX?which command to be use?

4 Answers   Cap Gemini, TCS,

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

0 Answers  

my source is sequencial file and my target is dataset. i am running the job in two node configuration file. my source having 10 records how the data move to target?

3 Answers   TCS,

Can you define merge?

0 Answers  

For more Data Stage Interview Questions Click Here
Categories