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
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?
What are the processing stages?
What are the types of hashed files in data stage
what are the errors,warnings in datastage
AGGREGATOR default datatype
What is a merge in datastage?
What is the roundrobin collector?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
Difference between ‘validated ok’ and ‘compiled’ in data stage?
Nls stands for what in datastage?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
how to sort two columns in single job in datastage.
What are iconv and oconv?
Lookup constraints
Define ds designer?