Page 1 of 1

Problem with Column Import stage

Posted: Tue Apr 21, 2009 7:54 am
by shruthija
Hi friends

I am running the column import stage, In the source file I loaded it with one type of filedefinition, and in the destination file it is loaded with the same filedefinition with two extra columns that are to be imported.

But when I run the job it is saying that, the extra added two columns were not found. The message was "Delimiter for <extra added column> were not found.

How to run it.
Please help me

Thanks in advance

Posted: Tue Apr 21, 2009 11:32 am
by dsuser_cai
the job log says it all. you need to Check for the delimiter. try to specify your own delimiter and test it. I use a Pipe symbol (|)

Posted: Tue Apr 21, 2009 12:57 pm
by kduke
You need to add the 2 columns in a transform.

Posted: Tue Apr 21, 2009 1:29 pm
by ray.wurlod
... or a Column Generator.

Posted: Tue Apr 21, 2009 1:33 pm
by pandujoy
add two more columns in the transformer

Posted: Tue Apr 21, 2009 1:34 pm
by pandujoy
add two more columns in the transformer