DSXchange

In a post-job subroutine you can read the Datastage job log from where you can get the reason for the job failure. If it is due to database down you can use DSSendMail function to send a mail notifying the database failure to the intended persons.

If I have understood your problem correctly, you can make use of Coalesce function in DB2 which substitutes a desired value whenever a null is returned from an expression. If you can explain more on what you need exactly, I can give you the pseudo SQL query.

Vignesh.

I think Lakshmi needs to revisit her post or reply before she clicks submit. Lot of spelling mistakes !! Juz kidding :) You need to change the preserve partition flag to clear at the place where it is throwing warning. But as you said, the warning sometimes will not be state precisely on which place...

I got it folks !! I put the syntax here. May be it will be of use to someone.

TRANSACTION_DATE BETWEEN '#TABLE1_START_DATE#' AND '#TABLE1_END_DATE#'

Thanks !!
Vignesh.

I tried using filter stage for doing this but ended up in the job abortion due to incorrect syntax in where clause. I explain you li'l bit more. Here in this job, we are passing the date parameter values to the job through a unix script. One of the columns input to the filter stage is a date column ...

Infact no other transformations involved. It is a straight pull from source table to 7 target tables based on the date range. So can I assume that filter stage gives a better performance.

Vignesh.

Hi In our project, we have a requirement like we need to forward records from one table to 7 other tables based on the value of a date column. If date falls in range1 then it should go to table 1 or if it falls in range2 then it should go to table 2 and so on. Which stage performs well in this case ...

We have one confusion of selecting either Lookupfileset or performing a direct lookup onto the DB2 table. We are looking into a dimension table which has around 150 million records and has 4 columns. Which is advisable ?? Either a lookup fileset or to perform a direct lookup. Also if it is a lookup ...

As Ray said, no such hashed file stage in PX. You can use either Merge, lookup or join to do your lookup needs. Also you can assign nodes depending on your PX server configuration to achieve partition and pipeline parallelism in which each node will do the operation parallely which eventually improv...

Hi all, I'm trying to ignore the duplicated rows from an input. I mean, this is the input: AAAA,BBBB,CCCC AAAA,BBBB,CCCC AAAA,BBBB,CCCC XXX,YYY,ZZZ XXX,YYY,ZZZ XXX,YYY,ZZZ and this is the output i want to get AAAA,BBBB,CCCC XXX,YYY,ZZZ seems easy, but am a newbie. thanks. Based on some key you need...