Hi All,
I have very simple dimension job whose source is sequencial file.Sequencial file has data like:-
"CUST_TYPE","E","Existing","N/A"
"CUST_TYPE","P","Prospect","N/A"
"CUST_TYPE","O","Others","N/A"
"CUST_TYPE","X","NOT AVAILABLE","N/A"
But in datastage env. it is skiping first line.
My setting in sequencial file is:-
First line as column name- False
Format:-
Delimiter:- comma
Final Del:- end
Quote:- double
Please help me to resove this issue
thanks
Weird result:- sequencial file reading improper data
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 132
- Joined: Tue Sep 04, 2007 11:38 am
- Location: NOIDA
-
- Premium Member
- Posts: 132
- Joined: Tue Sep 04, 2007 11:38 am
- Location: NOIDA
Assuming you aren't getting runtime warnings, if you do a "View Data" in the designer, does the first line get show? If yes, then most likely you are dropping that line somewhere in your job.
Addition (I just saw your 2nd post after writing my response)
The likely reason is that you are reading a different file or files from that which you think you are reading. Are you actually using wildcard "*"s as the file name?
Addition (I just saw your 2nd post after writing my response)
The likely reason is that you are reading a different file or files from that which you think you are reading. Are you actually using wildcard "*"s as the file name?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 132
- Joined: Tue Sep 04, 2007 11:38 am
- Location: NOIDA
So, did you check if there is any another file with similar file mask as specified in previous directory.
But being similar, should be added up to the existing file though.
If you put your file back to the earliar directory gives you only 3 record?
But being similar, should be added up to the existing file though.
If you put your file back to the earliar directory gives you only 3 record?
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
-
- Premium Member
- Posts: 132
- Joined: Tue Sep 04, 2007 11:38 am
- Location: NOIDA
Yes...when i am putting file back to earlier directory...its giving 3 records onlykumar_s wrote:So, did you check if there is any another file with similar file mask as specified in previous directory.
But being similar, should be added up to the existing file though.
If you put your file back to the earliar directory gives you only 3 record?