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 |
How can we improve the performance in datastage?
What is the difference between informatica and datastage?
1)How to do error handling in datastage? 2)Did sequential stage accepts .xl files ,xml? znd how?
what are fact tables and dimension tables? give example assuming one table.
How rejected rows are managed in datastage?
what is the main difference between sorragate key n primary key in one word
source contains 2 columns comes to target 4 columns how
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
how to change left and right links in join stage?
Hi, i did what you mentioned in the answer, i.e. source- >Transformer -> 3 datasets. Iam able to see the data in datasets but its not sort order... Can you tell how sort the data?? i also checked Hash partition with performsort.
plz tell me some dimentional and fact table names in banking project?
Hi guys, please design a job with derivation(solution). write exact conditions. My requirement Source table emp_no qualification 1 a 1 c 2 a 3 c 3 b Target table emp_no qualification 1 b 2 b 2 c 3 a Here every employer have three qualifications i.e a,b and c. what ever source table dont have some qualification, that will be move to target table. Like above. Hope u get the point. Thanks.