problem with folder stage

[kaushal.kumar@igate.com]

i am using folder stage to read files from load directory. My files are fixed width length file.I am dfining column1 as file name and column 2nd as record( which suppose to contain records of file) .but in my job its taking only first rows of file.Please help me what i need to define so that it will take all rows of file.

[gssr]

i am using folder stage to read files from load directory. My files are fixed width length file.I am dfining column1 as file name and column 2nd as record( which suppose to contain records of file) .but in my job its taking only first rows of file.Please help me what i need to define so that it will take all rows of file.

Check the datatype and the LENGTH of the Column2.

[kaushal.kumar@igate.com]

i am using folder stage to read files from load directory. My files are fixed width length file.I am dfining column1 as file name and column 2nd as record( which suppose to contain records of file) .but in my job its taking only first rows of file.Please help me what i need to define so that it will take all rows of file.

Check the datatype and the LENGTH of the Column2.

datatype=longNvarchar
Length=999999.
Please advice how to solve this

[chulett]

Use the Folder stage to read and process multiple XML files. For other types, it is a... less than optimal solution. What kind of 'loads' are you doing?

[Marley777]

Hi,
Would be nice if the folder stage was available for PX jobs. Is there a PX alternative to the folder stage? Trying to read all xml files from a given Unix directory.

Thanks.

[chulett]

That would be the External Source Stage and a search for that phrase in the PX forum should reveal the information you are looking for.

[eostic]

http://dsrealtime.wordpress.com/2007/12 ... -a-source/

[chulett]

Or that.

[arunkumarmm]

i am using folder stage to read files from load directory. My files are fixed width length file.I am dfining column1 as file name and column 2nd as record( which suppose to contain records of file) .but in my job its taking only first rows of file.Please help me what i need to define so that it will take all rows of file.

Are you looking at the ouput or You assume that folder stage reads only one row by the Link count? If later is the case, check your output. Folder stage will always have the link count as 1