DSXchange

Unfortunately, I have zero control over that.

Craig, do you think there is any other solution to treat consecutive delimiter as one for my original post? Excel has it so I find it hard to believe DS doesnt have any option.



Thanks again.

Thanks for your replies.

The problem with using single varchar and then convert function is that when a column has a space in it then it will treat it as a delimiter therefore I will again end up with consecutive delimiters and incorrect column mappings

E.g.
59.40
749.50

For testing purpose, as soon as I add a value to the 3rd column, View data works fine but when I remove that value - same error.

Hello All, I have a sequential file with columns delimited by a space. In all there are 4 columns in the source file. Config settings - 1. Delimiter = white space 2. Final Delimiter = end 3. Column Type = Varchar 4. Column Length = Not specified 1 2 3 4 51 01 07.04.2010 Note that column 3 has a <<sp...

Why have you got ? Are you trying to use SubString?

I have come across similar issues and mostly it is because your output column may still be String and not changed to Decimal? Is that SubString causing issues?[/code]

vinodn wrote: "Describe failed because of a missing column for INPUT."

You are trying to load a column in Oracle which is not present on the link coming into Oracle Stage?

devidotcom wrote:Thanks for the reply.
But i do not relie on the link count because the link count behave weird at times and give some different count I don't know why.

Does anyone know why the link gives weird numbers? Is that a bug?

[quote="shaonli"]I looked into the MultiLoad report.There I found this statement ========================= 0003 drop table ABC.ET_ABC; **** 23:13:58 UTY1008 RDBMS failure: 3807, Object ABC.ET_ABCdoes not exist. 0004 drop table ABC.UV_ABC **** 23:13:58 UTY1008 RDBMS failure: 3807, Object AB...

As sud said..use Tail stage and set the number of lines to 1 this will give you the last row in your file. Now, you can compare your key field to the key field of this tail -1 record and then process accordingly.

Hope that helps

@Keshav we found that the ORCH table created for this teradata table was having very high skewness factor.. ORCH tables will only come into play when you are using TeraData Enterprise stage. But, I was using PX stage(which I should have mentioned) so that wasn't an issue for me. Thanks mate @hamzaqk...

Hey Everyone, I got a problem! I 'm trying to load about 15 million rows in Teradata enterprise using bulk load. To be specific, using FastLoad. My dataloads keeps on failing around 9-10 million rows and that too inconsistently(meaning could be more or less then specified). I dont have any access ri...

Right... we all saw your fake sql in the first post. :wink: As noted, any valid SQL will work in DataStage. What precisely is the problem you have when you try to use this in a job? I appreciate your response, Craig. I will try run that job again and keep you posted about it. Also, I had a chat wit...

Thanks for your reply Craig. Basically, I have written a sub query as mentioned in my original post. It goes as follows: select SubQuery.columname from ( select colum1,column2,column3 from tablename group by column1,column2,column3 ) from subquery Works great in SQL Developer. So, I guess should wor...

Thanks for your reply Craig. Basically, I have written a sub query as mentioned in my original post. It goes as follows: select SubQuery.columname from ( select colum1,column2,column3 from tablename group by column1,column2,column3 ) from subquery Works great in SQL Developer. So, I guess should wor...

@ Craig, Keshav. Thanks for your reply Well, that's what I have been doing..writing SQL queries in user defined area. But, it seems DS does have issues executing sub queries or say group by queries. Is there a work around to write group by queries within any stage? Or If you have a look at the query...