how can we do null handling in sequential files

Answer Posted / venkat

go to target level of sequence file,click on format tab and then click field format select and put the value=''

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you implement SCD2 using join, transformer and funnel stage?

1089


Highlight the main features of datastage?

615


What are the types of containers?

687


What is difference between server jobs & parallel jobs?

623


What are datastage sequences?

670






Define Job control?

679


Define APT_CONFIG in Datastage?

666


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?

1745


What is the flow of loading data into fact & dimensional tables?

596


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

659


AGGREGATOR default datatype

935


What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

1635


Differentiate between validated and Compiled in the Datastage?

642


What is the difference between hashfile and sequential file?

720


What are the areas of application?

660