DSXchange

Hello sainath,

Thanks for the reply. Can you help me how to pick the data from the log.

Hello Ray,

Thanks. I tried that and the job is getting aborted but i dont see the first row written to the file instead a zero byte file is produced. I even tried using peek stage and from peek stage i have written to a Seq File. But in vain. Is there another way.

Thanks for the help

Hello I have a scenario where i have to abort the job if i see any rejects out of oracle stage.I am doing only inserts in the oracle stage. So i have changed the property in the oracle stage to ouput reject rows=true. But the requirement is i need to capture the first rejected record from the oracle...

Thanks guys for all your inputs. I am going to try few things suggested here during this weekend and on Monday and will let you know the results! Just my obervation: I believe that +|+ format is handled in GBNAME rule set. when i send Vekant K Dodda to GBNAME its actually parsing the name. so i am p...

Hi All,

Any thoughts for my DateConversion issue

Dodda, One way to make it work is using classification overrides. Just double click on the rule set then the Rule management windows will pop up: Rules Management tool --> Overrides --> Classification Classify all your names base on your investigation frequency report Thanks Julio for your reply. i...

I'm facing an issue with the result of Date Conversion function . I processed the same input file in different servers .In one server i'm having a version Datastage 7.5.1 .And another server i'm using Datastage 7.5.2 . But i'm getting diferent ouptut values for one of the field (DAY_OF_WEEK ) In the...

Hi all,

Can i take a backup of my project ,While the jobs are running?

Also could you please brief me about the Job Executables option in Export tab in datastage manager.

thanks

Hi all, I had worked a little on Qualitystage 7.5( not an expert). while standardizing names when i use literals (ZQ) i got Matchfirstname and soundex results, but when i do the same in 8 its shows unhandled pattern. example: ZQ MARTIN ZQ K ZQ SMITH ZQ VENKAT ZQ K ZQ SMITH The above two strings when...

Hi All, I need some help regarding the FTP stage. I'm having a job with FTP stage used to retrive file from another server. While running the job i'm getting the Fatal errors. And in the properties i set Unix style Termination for Line termination property Test_SAPFIAdjDocFct..Seq_SAP_FI_Documents.I...

That would be a horizontal pivot of rows to columns, search for that phrase here to find the many (many) conversations we've already had on the topic. Hello Chulett, Thanks for the reply.i looked at the horizontal pivot pdf but my requirement seems to be different. My aim is based on the key (col1)...

Hello I have the below requirement. col1(key) col2 col3 col4 1 A B C 1 D E F 1 G H I 1 J K L 2 M N O 2 P Q R 2 S T Q 2 U V W based on the key column i need to concatenate col3 values. the output should be as below col1 col2 1 BEHK 2 NQTV any ideas would be appreciated. Thanks

Hello, I have a requirement where in the sequence my first job would be to delete all the records from the table and the second job would load the data. Is there a way that i can truncate the table as part of my first job rather than delete. If so which option should i use to truncate the table in t...

I defined two columns in datastage job. And i marked Literal as key column.

Hi Chulett,
I searced the forum before posting my query..
But i didn't get enough inforamtion.
So, could you advise me , how to proceed..

Thanks in advance.