DSXchange

Vijayindukuri,

That will not work. You have to open your xls in Excel and 'Save As' CSV (MS DOS). Renaming the file leaves it in Excel format, as you have seen, unreadable by a text editor.

Rob

Vijayindukuri,

Ensure that you have the Line Termination radio button set to DOS Style (CR LF).

If you have it set to UNIX Style, the file itself will have a line terminator of (x0D0A) but DS is expecting (X0A). DS thinks the (x0D) is an extra column.

Rob

Ray, Emma, Thanks and Merci Beaucoup for the input. When you open the table definition in the Repository and click on the Layout tab, then choose Parallel option, is the schema displayed according to your expectations there? You might see, for example, record_delim='\n' in this listing. Nope, it's n...

All, By searching the forum on the string 'schema file' I determined how to generate some examples of schema files, however, I'm not getting what I expected. I have a file defined in a Column Import stage that has has a record delimiter string defined for the Record Level and a Delimiter string defi...

I believe only single-character delimiters are handled. In the end, it was OK with the 6 character record delimiter string ||^^||, so long as I didn't also define the column delimiter to the same characters (at this point of the flow, I'm treating the whole input record as a single column). Later o...

Assuming the data is as shown in your post, you will have to separate the data based on the ',' delimiter before implementing the solutions suggested by Arnd and Guru. Rebuild the string, putting the ',' back in after the manipulation.

Rob

Kumar,

Assuming format YYYY-MM-DD, Craig's suggestion breaks down to

Year = in.timestamp [1, 4]
Month = in.timestamp [6, 2]

Are you looking for more than that?

Rob

All, Has anyone had any experience using the Upsert capabilities of the TeraData MultiLoad Stage, using either MultiLoad or TPump? The TeraData documentation suggests that the transaction is quite efficient, having implemented a feature called Atomic Upserts. http://www.teradataforum.com/teradata_pd...

Ray, A brief history.... This is the file I have posted about earlier in the Server forum (when I was trying to solve our design issue in Server!). In short, we have a file with huge columns, 32k, and embedded weirdness, including terminators of all flavours and potentially any character you can thi...

Hi, Guru, Here it is. Copy_of_Input_File,0: Error reading on import: Copy_of_Input_File,0: Consumed more than 100000 bytes looking for record delimiter; aborting Copy_of_Input_File,0: Import error at record 1. Copy_of_Input_File,0: Operator's runLocally() failed. APT_CombinedOperatorController,0: Op...

It appears that there were two things going on. In the initial read, I was reading the whole input as single column. I had defined a character string as a row delimiter and then the same string as the column delimiter, this is what DS was unhappy about. When the job aborted, the data was too big for...

sudhakar_viswa wrote:Hi rwierdsm ,

It is nullable column.

Thanks,
sudhakar[/i]

Check to see if the row has a null date.

can any one help me asap. Tsk, tsk, tsk, (like my sister used to say!) Sudhakar you've been around long enough to know that will earn you a tongue lashing! Is your target field defined as not null? It message seems to be indicating that you are loading null values into a not null column. Rob W

Saik, I think this is really more of a display issue in whatever tool is used to access the data in Oracle. However, if you wish to have the data left justified instead of right justified in the Oracle column, just concatenate a blank to your input column, i.e. TrgCol1 = SrcCol1 : ' ' Hope this help...

All, I'm having all kinds of fun with my first EE job. I'm trying to load an input file with the following structure: NUMBER char(10) CATEGORY varchar(25) MISC_ARRAY1 varchar(5000) RB_APPROVALS varchar(100) RB_APPROVALS_BY varchar(500) RBC_LOCATIONS varchar(200) RBC_LOCATIONS_TASK varchar(500) RBC_E...