Hi all, can u explain header and trailer records in file?
If a file has header and trailer /master-detail records how
will you read it in datastage?
Answer Posted / subhash
Header: is nothing but Column names/Structure of the table
trailer: is something like FOOTER of the page/file
if file has Header, while reading the file set 'TRUE' for
'First Line is Column names'--
If set true, the first line of a file contains column names on
writing and is ignored on reading.
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
How a routine is called in datastage job?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
What is usage analysis in datastage?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
Difference between ‘validated ok’ and ‘compiled’ in data stage?
in oracle target stage when we use load option and when we use upsert option?
Name the different sorting methods in datastage.
what are the errors,warnings in datastage
How can one find bugs in job sequence?
What is the method of removing duplicates, without the remove duplicate stage?
How do you run datastage job from the command line?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
What is ibm datastage?
Difference between server jobs & parallel jobs?