how can we do null handling in sequential files
Answers were Sorted based on User's Feedback
Answer / kiran
go to target level of Seq_file ,click on Format Tab then
click on field format and select null field values=0.
Is This Answer Correct ? | 19 Yes | 2 No |
Answer / 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 |
What is Horizontal transformation, vertical transformation,diagonal transformation?
Distinguish between informatica & datastage. Which one would you choose and why?
i have source like deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like target1 deptno,sal 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformerstage
In a table 100 records are there after 50records job is aborted how can u insert all records in target table.
WHAT ARE THE COMMON ERRORS IN DATA STAGE?
Emp login_timestamp Logout_timestamp A,2019-02-01 02:24:15,2019-02-01 04:59:42 B,2019-03-29 14:43:30,2019-03-29 20:22:00 ABC,2019-03-29 12:43:00,2019-03-29 23:22:59 In the above calculate the duration of hours spent in office for each emp in datastage.
how to abort the job its matain duplicates?
What are sequencers?
how do you pass parameters in a script?
Explain usage analysis in datastage?
what is operator combinality in datastage?
What is the difference between Link collector and Funnel Stages?