DSXchange

Hi Gurus,

folder stage----->transformer----->sequential file.

folder stage has a text file called dept.

i defined the folder stage properties (columns) as

filename varchar primary key 255------------> this gives the filename
record longvarchar 9999999999---->lists the contents of file.

i defined the same columns in my target stage(sequential file)

i have defined sequential stage properties as.
first name is file name.

Its running fine, but when i try to view data.Iam getting warnings.
INVALID QUOTES:"DEPTNO","DNAME","LOC".
O/p is in the below form.
filename
salma
10
20
20
My problem is it doesn't display the Source columns headings and the entire data in these columns.

cheers;
vijay

Change the Delimiter and Quote character to 000 in the target sequential file and check if you still get the error.

Hi Gurus,
I changed the de-limeter to . and quote character to 000.

My o/p data is in this format.

filename
salma"deptno","dname","loc"
20 accounting boston
10 ........... .........
15 ............ ..........

when i click on tab: view data:NLS_READ_DE-LIMETED()-INVALID QUOTES.
what i mean to say, i got the entire data, but deptno's are not under the column deptno, i mean its not organized.
Thanks guru once again, but can u help me , so that i can get much more organized data.

cheers;
vijay

vijaykumar wrote:what i mean to say, i got the entire data, but deptno's are not under the column deptno, i mean its not organized.
Thanks guru once again, but can u help me , so that i can get much more organized data.

I guess that's how its going to look.
I don't think you can align them more accurately in this case.

I'm confused as to what you are trying to do. You say that you used the same columns from the folder stage in your target sequential stage.....filename and contents. If you try to "view data" with that, and left things "as is" with ',' as the delimiter, it most certainly will mess up, because you have many more "columns" (based on your sample data) than you have meta data on the link.

As suggested earlier use 000 in BOTH the delimter and the quote character and no extra things will be inserted into your data. That will help, and is the best technique for any "non-formatted" output that you might want to generate. I use 000 for both properties whenever I want to write out an XML document cleanly.

What are you really trying to accomplish? If you already have column names in the first line of your data, this is going to truly be screwy for "view data" which would require that you first imported those columns as part of a Table Definition.

Ernie

Welcome aboard Ernie.