DSXchange

Gurus,

Can anyone help me for deciding on anyone of approach.

I am reading a ( Empdet.csv )sequential file with the below columns EmpNo,EName,Salary,DeptNo 1,SAM,40000,10 2,RAM,50000,20 3,RAJ,30000,30 4,ALI,20000,40 Columns datatype is defined as CHAR for all the fields with the Format properties as Final Delimiter = End Delimiter = comma Quote = none I am abl...

I have a requirement in which, CSV file is the source, I need to get unique records based on a key column and load in a target fixed width file.I have 2 approaches, which of the below works fine, in terms of logic and performance. can anyone help me to list the pros and cons of the below 2 approache...

I am creating a fixed Flat file in Datastage, with a value 0 for a column . Can mainframe application read a fixed width flat file with a value zero(0) for a column with datatype S9(9) COMP. Also, can -1 or 0 ( zero) value be populated to S9(4) COMP? What conversions in datastage , do I need to make...