Hi,
The basic difference between ASC and CSV is the "Column Width.
ASC format has fixed column width for each field where as in CSV, each field is seperated by a character like ",".. (The seperator could be anything otherthan comma like "|" or any character.
At the time of data load, we will select the file format based on the source file provided.
Ex:
ASC file: (Extension ".txt")
Sl No Name Country Category
0010 Charles USA A
0011 David UK B
In the above example, each field has a fixed length no matter of the value (SlNo (10), Name(20), Country(10), Category(10))
CSV file: (Extension ".csv")
Sl No,Name,Country,Category
0010,Charles,USA,A
0011,David,UK,B
There are some scenarios where you should select CSV even the source file is not ".csv".
Ex: (Extension ".txt")
SlNo|Name|Country|Category
0010|Charles|USA|A
0011|David|UK|B
In the above example, the file format is not ".csv" it is ".txt" but we'll load it as a csv file In the "Data Seperator Field" of InfoPackage, you have to mention it as "|".
There is no specific scenario given in the requirement. That depends upon the file format given. Let me know if I could answer your question.
Regards,
Shashi