DSXchange

We might need XMETA table names to fetch stage names,link names used as part of each jobs.And also jobs part of each sequence.
(based on the names given to each,we need to validate if required naming standards had been followed.)

Hi All,

Do we have any idea how to build a data stage accelerator for data stage coding standards?

Thanks for advanced help...

Hi All,

Can you please explain how to Add Carriage return in the swift file in data stage?

Thanks for your Advanced Help :D :D

Hi All, I have below requirement.Please help me how to resolve? Picking the columns dynamically from sequential file and masking the data. Example: File contains 20 columns out of these 20 columns i need to mask the data for the columns 4,7,13,19. Next run same file contains 50 columns out of these ...

chulett wrote:Your metadata doesn't match what it found in the file. Perhaps your EOR setting?

Yes it is working properly.....In meta data total length is 160 .but, data file length is 161 charactes.
now it is working .....

Thanks for your reply....working fine.

Hi all,

in data stage i have one requirement.
In data stage i have to assin if

Monday = A or
Tuesday = B or
Wednesday = C or
Thursday =D or
Friday = E or
Saturday = F or
Sunday = G.

Let me know how to find today is monday or tuesday or ........Sunday.

Thanks for your advanced help....

HI All,

I am getting below warning message.Let me know how to resolve warning

Import consumed only 460bytes of the record's 461 bytes (no further warnings will be generated from this partition)

My source is Complex flatfile and fixed with data.

Hi All, i have one doubt... 1.I have two jobs , first job output(dataset) is second job input.If i will execute first job is eight nodes and second job is two nodes, second job will execute with out warnings or not? 2.I have two jobs , first job output(dataset) is second job input.If i will execute ...

Thanks for all replies...

I got solution.

After I added APT_NO_IOCOMM_OPTIMIZATION environment variable it is working fine...

Hi Priyadarshi kunal, I am using 9.1 version.I am getting this error only one job when I am using multi node configuration. Could you please let me know in which situation this error will come. I have not faced this error previously. Anyone please help me how to resolve this error... Thanks in Advan...

Hi All, I am getting below error. APT_IOPort::readBlkVirt: read for block header,partition 0,[fd,5], returned-1 with error 10,054(Unknown error). When I executing job with single node I am not getting any error or warning messages.But, when I am executing four nodes I am getting above fatal error.Bu...

Hi All, My source column datatype is INT 2 and My output column datatype is TINY INT 3 when I execute job I am getting below warning message. Implicit conversion from source type int8 to result type uint8 possible range limitation Please advice me how to convert INT to TINY INT in datastage? Thanks ...

Hi All, I have some records in EFF_DATE column. In this i have some NULL values and '0001-01-01' and '1559-01-01' records and i have some after 1990's records. if date > 1800 i need to pass same input date value. if date is NULL value i need to pass Null value only.when date is '0001-01-01' and '155...

Thanks Eric,

Right now it is working fine .In my date field three values are coming before 1753.
After I wrote constrain in Transformer Stage it is working fine.


Thanks for all replies!!!