DSXchange

I think you can do this by using DSGetLogSummary

U wil need to write a routine and use the function DSGetLogSummary, the result of which you can store or write to a file and then load that file into the database.

Check out the BASIC guide for more information on DSGetLogSummary.

Is there a way to have DataStage perform data type validiation ? What I mean is, Is it possible to perform meta data validation of incoming data ? I want to ensure that the source columns are of the same datatype as defined in the input column of the stage. Are such things possible in DataStage PX e...

Currently in our project we are making use of the environment variable, but we would definitely like to look at the scripting option, though I am not sure how.. 1> I am wondering how do I create a file with encrpted password?? As in somewhere in the script I will definitely need to mention the passw...

Friends: I encounter a wierd problem, I have a job that has multiple instances. All instances run fine except one.. Now I am wondering why ..? From a few posts I figured out that a NULL is transformer could be an issue.. I check for NULL values if any in the transformer and I am sure that this is no...

Friends

I got a solution to this issue. The thing is that in the transformer I was trying to add NULL + NULL or NULL+<value> and so there was this error.
I fixed these NULLS using NULLTOZERO and it works absolutely fine.

Thanks ArndW, I believe you got me started.

Cheers !!

I am not using any operations in the transformer stage. And the field is set as nullable.

Friends: I get the following errors 1. (Warning) APT_CombinedOperatorController(1),1: Field 'po_mcptm_othoutsum' from input dataset '0' is NULL. Record dropped. 2. (Fatal Error)xfm_StgDM2StgMN_po_vo_mob_temp,0: Failure during execution of operator logic. 3. (Fatal error) APT_CombinedOperatorControll...

chulett wrote:Isn't that just a matter of sort descending on calls and constrain to five rows? ...

No really, because I am looking for the top 5 contact for each customer.. Anyway, nice thought.. But how do I constraint to take top 5 contact for each customer?

Friend: I am trying to create a parallel job wherein I need a Rank function like functionality. Scenario: Consider a Call phone customer who has a high usage of calls. Now I want to count the no of calls made by the customer to his contacts, and then list the top 5 contacts. I can easily do the firs...