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 |
5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10
how can we create tables in datastage?
How the ipc stage work?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
how to sort two columns in single job in datastage.
why we use parameters instead of hard code in datastage
What is job control?
What is data partitioning?
i hav source like this . deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like this target1 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformer
col1 123 abc 234 def jkl 768 opq 567 789 but i want two targetss target1 contains only numeric values and target2 contains only alphabet values like trg1 123 234 768 567 789 trg2 abc def jkl opq
What is use Array size in datastage
what is sparse lookup?