DSXchange

Thanks a lot every body

I used That supress Zero option . It is working fine if the target is varchar.But my target coln is decimal(6)

In client side they are loading it in to some other database.There it is like decimal (6). will it wont give problem if it varchar in file.

Delimited with ,

Yes. Our client need it in that format :(

Supressed Zero as u said . But my target is Decimal. while inserting again i convert it in to string to decimal. still it is showing the same result.

Hi , From source(teradata) I am extracting a decimal coln with datatype decimal(6) and putting it in to a text file with datatype(decimal(6)).My problem is ,for source value 500 i am getting output as [b]000500.[/b] (with the period). I dont know how to supress this zero and period. :( . if any body...

I wrote a unix script to do this operation.Its working fine. :D

Any way thanks

Hi , After extracting the data from tables i have to notify through mail with table names,count of records and then time(In Email body). My doubt is , in notify stage in seq I was able to parameterize the count and table name in Subject. But according to the req I need all those in Body part. I am n...

No we havent resolved it... we are looking in to some other issues...

Our client changed the requirement.

Anyway thanks Ray..

Below given is my job...

seq file------->transformer----->seq file

In target file I need the column names as well as the source count in trailer. The output should be like ABC|source count (A,B,C are column names).
could any body tell me how to implement this in Parallel job?