I have 3 Input files having same layout.
Customer_AAAA.txt
Customer_BBBB.txt
Customer_CCCC.txt
I am using Sequential file stage to read them(File Pattern as Read Type - Customer_*.txt)
The input File has 5 Columns.
I need to load that to a table which has 6 Columns.
The extra column in the Table is SOURCE_FILE_NAME which should have the value of the File name from which the data has come.
Any way we can do this in Datastage ?
Thanks for your time in viewing this post and reply in advance.
Sequential File Stage - Query
Moderators: chulett, rschirm, roy
Sequential File Stage - Query
Regards,
Shank
Shank
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
I dont think file name column property gives you file name,if it is multiple files(File pattern).
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
make APT_PATTERN_USAGE_FILESET=true in your job.
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/