Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

options available in sequence job to run,validate?

0 Answers   CTS,

what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs?

9 Answers   HCL,

What is the importance of the exception activity in datastage?

0 Answers  

I have a scenario like Deptno=10---->First record and last record Deptno=20---->First record and last record Deptno=30---->First record and last record I want those first and last records from each department in a single target. How to do this in DataStage, any one can assist me. Thanks in advance.

8 Answers  

how can you generate sequence number using only the sequential file stage?

3 Answers   TIAA CREF,

how can we create a Sorrogate key in transformer stage? I want it in parallel mode

2 Answers   Syntel,

difference between function and procedure...

1 Answers   IBM,

Explain connectivity between datastage with datasources?

0 Answers  

Describe the main features of datastage?

0 Answers  

i have one table with one column in this column i have three rows like 1,1,2 then that rows populate to target as first tow rows as one row and remaing row as one row how it posible? COLUMN_NAME SHIVA RAMU MADHU THEN I WANT TO LIKE SHIVA AND RAMU IN ONE ROW AND MADHU IS ONE ROW IF ANY ONE KNOW PLZ TELL ME

3 Answers   Cap Gemini,

What is the difference between an operational datastage and a data warehouse?

0 Answers  

count number of deptno in a emp table?

2 Answers   IBM,

For more Data Stage Interview Questions Click Here
Categories