Dynamic File Layouts
Posted: Thu Jul 05, 2007 1:15 pm
hi,
I am using datastage to create sequential files.This is a fixed width file with 8 columns as follows
EmpNo,FrstName,LastName,SSN,DeptNo,PhoneNo,Address1,Address2
This is a standard job that i use a number of times.Most of the times the layout remains the same, in certain cases i have to change the field positions
For example in below example field positions Phoneno,Deptno,SSN have changed from the standard layout
EmpNo,FrstName,LastName,PhoneNo,DeptNo,SSN,Address1,Address2
It can also be as follows
EmpNo,PhoneNo,FrstName,LastName,DeptNo,SSN,Address1,Address2
How do i handle such scenarios?
Please help
Thanks much in advance.
Sam
I am using datastage to create sequential files.This is a fixed width file with 8 columns as follows
EmpNo,FrstName,LastName,SSN,DeptNo,PhoneNo,Address1,Address2
This is a standard job that i use a number of times.Most of the times the layout remains the same, in certain cases i have to change the field positions
For example in below example field positions Phoneno,Deptno,SSN have changed from the standard layout
EmpNo,FrstName,LastName,PhoneNo,DeptNo,SSN,Address1,Address2
It can also be as follows
EmpNo,PhoneNo,FrstName,LastName,DeptNo,SSN,Address1,Address2
How do i handle such scenarios?
Please help
Thanks much in advance.
Sam