1.

While loading data from flat files, when separators are used inconstantly. How this will read in BI load?

Answer»

If separators are used inconsistently in a CSV file, the incorrect separator is read as a character and both fields are merged into one field and may be shortened. Subsequent fields are then no longer in the correct order.



Discussion

No Comment Found