how to handle null values in sequential file?
Answer / satyanarayana
GO to the Format tab in the sequential file then select the
Field defaults option and then select Null field value
option at right side bottom and then provide the
value...........
| Is This Answer Correct ? | 28 Yes | 3 No |
What are the types of hashed files in data stage
on how many columns we can perform aggregation in the Aggregator stage?
i have a scenario like two columns(Empno, Ename) in that duplicate records are there, so my question is how to get second duplicate record in datastage.
what is the main differences between Lookup, Join and Merge stages?
How to Convert the columns into rows?
input Name Salay Sam 10 Sam 30 Sam 20 Ram 40 Ram 50 Output should be Name Salary Count Sam 10 3 Ram 40 2 get min salary and count of name . OutPut 2 Name Seq Sam 1 Sam 2 Sam 3 Ram 1 Ram 2
Sequential file i have one record,i want 100 records in target?How can we do that?Pls explain me and what stages are there?What logic?
How can i approach to write datastage 7.5 Certification? and how much they will charge for examination .What exactly should i do? Can anyone guide me plz?
what is the difference between 7.1,7.5.2,8.1 versions in datastage?
What are operators in datastage?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
What are the types of containers in datastage?