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
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 |
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 |
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 |
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 :(
Differentiate between validated and Compiled in the Datastage?
How do you find the number of rows in a sequential file?
if we take 2 tables(like emp and dept), we use join stage and how to improve the performance?
what is flow of project?
how many datamarts we will use in real time project and when will use the datamart?pls send the replay early
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
how to abort the job its matain duplicates?
how many types of sorting the data in data stage?
Define Data Stage?
how CAN we remove duplicates in dataset?
what is .dsx files