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 do u call shellscript/Batch file from DS?
where we use column generator stage in real time scenario?
on how many columns we can perform aggregation in the Aggregator stage?
1.How do u handle NULL in sequential stage. 2.Difference between switch stage and filter stage.
You enter values in a schema file for RCP and you also entered values in sequential file? which one will it take?
What is the difference between operational data stage (ods) and data warehouse?
how to load meta data
What is the difference between in process and inter process?
Distinguish between informatica & datastage. Which one would you choose and why?
Hi, I am getting data from sequential file like below column1 A&B C&D A&E X&Y&Z v&x But I need the target column as like below column1 A and B C and D A and E X and Y and Z v and x
What are constraints and derivations?
What is the different type of jobs in datastage?