DSXchange

VarChar(9) is not big enough - you need at least VarChar(11) - you have nine significant digits, a sign and a decimal placeholder. Where do you expect the third decimal place to come from, given that your source column only has two? Source column has three decimal places. is there any other way to ...

divesh wrote:Looks like your target field datatype is double/dfloat after the transformation.
Can you try making it Integer 10

Its actually varchar(9)

Hi, I am doing transformation on decimal value to feed into flatfile incoming data has field which is decimal(with two decimal places) i need to convert it into integer in COBOL format 9(6)v9(3) i am using derivation right("0000000000":(column.value*1000),9) it works fine with some value e...

BMSK wrote:First read the file as its comes through sequential stage, Then put copy stage and arrange colum as you needed...


BMSK

can u elaborate the approach

any one has any idea

If it's always the same six fields the first thing I'd be doing is getting the provider of the file to be consistent. If you can't do that, you need to determine which column is which. If there are column headings this ought to be easy. In a Transformer stage you could use RCP to direct the correct...

If it's always the same six fields the first thing I'd be doing is getting the provider of the file to be consistent. If you can't do that, you need to determine which column is which. If there are column headings this ought to be easy. In a Transformer stage you could use RCP to direct the correct...

HI I have a question i have few csv file in my server and the columns changes very day and file to file. like for example for invoice1.csv columns are: Invoice number, customer_id, Valid_from, Valid_to, extraction_time,user_code,emp_id and second file invoice2.csv columns are: extraction_time,user_c...

Yes its working thank you

i used same expression mentioned the article and used external source stage instead of sequential file stage it gave me error saying argument list is too long. but i worked it around and now its importing 303 files but only file names not the xml data. when i hit view data its just showing me just t...

design: sequential stage ---->Xmliput------->dataset table definitions: Data longvarchar 9999 Xml schema definition. sequential file settings: file pattern #FilePath#/META.INVOICEDOC.* error: file not found in directory. and one more thing apart for invoice XML i get one more XML claims. META.CLAIMD...

Hi Chulett well my concern was that to read the file i need to give the ls command like: ls #filePath#/Meta.Invoice.* because the system generates the filenames automatically. i dont have any problem in reading a single file using sequential or external source stage my concern is how to do it for mu...

chulett wrote:What "wasn't successful" about your file pattern attempt? Switch to using an External Source stage as detailed here ...

i used ls -l /filelocation/META.INVOICEDOC.* for sequential file.

i tried External source stage but it shows error in args()

HI, I am Designed an Parallel job using Sequential File to read XML document. But in production it supposed to read Multiple XML document i tried file pattern option but wasn't successful in doing so. work flow is every 6 hours XML document are storied in server location and these ment to be process...

i am working on mapping. I have doubt. source column metadata are: audit_id, condition_type, condition_value target column metadata are: audit_id, audit_type, final_value i am using transformer, if condition_type="un audit" then audit_type= condition_value if condidtion_type="kkk"...