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

I want capture UnMatched records from Primary source and secondary source in JOIN stage?

3 Answers   TCS,

What is the difference between the local container and shared container?

0 Answers  

Scenario : I have 2 jobs say job A and Job B with parameters x and y respectively. I need to create a sequence job. If we pass parameter x then Job A should run, If we pass parameter y then Job B should run, if we dont pass any parameter then Both Job A & B should run.

4 Answers   iGate, Thirdware,

which is the most complex job in your career? Please tell me answer?

2 Answers   IBM, Wipro,

country, state 2 tables r there. in table 1 have cid,cname table2 have sid,sname,cid. i want based on cid which country's having more than 25 states i want to display?

3 Answers   Wipro,

how to unlock a locked job in datastage 8.0

3 Answers   HCL,

Define ds designer?

0 Answers  

What are the steps needed to create a simple basic datastage job?

0 Answers  

what is the main differences between Lookup, Join and Merge stages?

9 Answers   HCL,

i 10 jobs first two jobs are runing in 2nodes,next 2 jobs are running in 4 nodes, next 4 jobs are running in 6 nodes and the remaining jobs are running on 10 nodes. how to change the node configuration?

2 Answers  

Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

0 Answers   Cap Gemini, TCS,

how can we generate row values like 1 1 1 2 2 2 3 3 3 using col generator plz let me know

2 Answers  

For more Data Stage Interview Questions Click Here
Categories