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?

Answers were Sorted based on User's Feedback



Hi all, can u explain header and trailer records in file? If a file has header and trailer /master-..

Answer / datastage4you

Whenever there is any header and footer with file, those must identifiable like First line will be header or last line will be footer or by some column info (row type)

so if data follows first criteria, use unix or datastage head and tail to extract those

thanks
www.datagenx.net

Is This Answer Correct ?    2 Yes 0 No

Hi all, can u explain header and trailer records in file? If a file has header and trailer /master-..

Answer / 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

Hi all, can u explain header and trailer records in file? If a file has header and trailer /master-..

Answer / sreeni

We can use Read Method:Whether to specify filename:"Path"
Options we can use filter option to remove header & footer
using unix command "sed 1d;$d"

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Data Stage Interview Questions

hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column"  hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column" i have no idea, what should i do..please help :(

3 Answers  


Differentiate between validated and Compiled in the Datastage?

0 Answers  


How do you find the number of rows in a sequential file?

0 Answers  


if we take 2 tables(like emp and dept), we use join stage and how to improve the performance?

5 Answers   Cap Gemini,


what is flow of project?

0 Answers   HSBC, IBM,






how many datamarts we will use in real time project and when will use the datamart?pls send the replay early

2 Answers   Tech Mahindra,


if the source file is CID,CCODE,CONNDATE,CREATEDBY 0000000224,1000,20060601,CURA 0000000224,2000,20050517,AFGA 0000000224,3000,20080601,TUNE 0000000225,1000,20020601,CURA 0000000225,2000,20050617,AFGA 0000000225,3000,20080601,TONE AND TARGET is oracle following are the validations cid loaded with unique records leading zeors has to be deleted while loading cid in target load only customer who got early connected to company conn_date should be loaded into oracle date format cid datatype is varchar2 in target conn_date is data datatype ccode is varchar2 0000000224,1000,20060601,CURA 0000000224,1000,20060601,CURA

2 Answers  


how to abort the job its matain duplicates?

0 Answers   TCS,


how many types of sorting the data in data stage?

1 Answers   BoA, IBM,


Define Data Stage?

0 Answers  


how CAN we remove duplicates in dataset?

2 Answers   IBM,


what is .dsx files

3 Answers   IBM,


Categories