DSXchange

Hi ray.wurlod, I am using this function in a Transformer to which some decimal field weer coming..When i am passing them to the target file , i am getting those leading spaces...So, i was giving Trim function in the Transformer derivation..But, i also tried using Fabs before...Both were working fine...

Hi,


Continuation to the previous post i was getting a space leading to each record...What might be the reson for this..

Hi, In the datastage help, for decimaltostring function it is given that, 'fix_zero' By default decimal numbers comprising all zeros are treated as invalid. If the string fix_zero is specified as a second argument, then all zero decimal values are regarded as valid. But in my case i have some decima...

Hi ArndW,


Your idea was good..But i have tried in other way..

I made the transformer into sequential mode and in the input properties i enabled sorting, unique options and taken it in the decending order...Then i took the @outrownum = 1...

Its working fine...

Hi ArndW, Thanks for your earlies reply...... Can you be please more specific.... Let me give my requirement with an example... Suppose i have a field A which will have two date records with data type Date... 2005-11-21 2005-11-22 The two records i will get from the same column...From this column i ...

Hi all,


In one of my requirements i have to find the Max of two dates which are coming from the same input link and got to pass the max value to the output.
If i am not wrong Max() functions works for integer datatypes...Is there any way around to get this...

Hi all, In one of my requirements i need to use the @INROWNUM function.When i was trying to use that, the job was working fine.But all the records were dropping. I was giving a constraint @INROWNUM > 1. I had to read from the second record. Where as, it was working fine in the server jobs..What migh...

Hi all,

Do we have 'Stage using filter command' option in Parallel jobs in the sequential file stage like we have in Server jobs. If yes where can we enable that option.

Hi ArndW,


None of the icons of the Transformer serves this problem..If i am not wrong the link execution order is not related to this...

Hi all, When i am trying to remove duplicates from the iput link of the remove duplicate stage, it is giving an warning as, Remove_Duplicates_367: When checking operator: User inserted sort "Remove_Duplicates_367.DSLink358_Sort" does not fulfill the sort requirements of the downstream oper...

Sorry guys...This message should be given parallel jobs..

Hi all, When i am trying to remove duplicates from the iput link of the remove duplicate stage, it is giving an warning as, Remove_Duplicates_367: When checking operator: User inserted sort "Remove_Duplicates_367.DSLink358_Sort" does not fulfill the sort requirements of the downstream oper...

Hi all, My problem might be a basic problem for all you people... I have a transformer from which four links are going out.Then after running the job.I had to link one more kink form the same transformer.Now when i am doing this , the fifth output link which i was trying to join was going up of the ...

Hi,

Kumar , what you have said is right...I have tried an other way around to accomplish my requirement.One more thing is , does the aggregator behaves the same way as an SQL query..??

Hi kirtikumar and kumar_s, My requirement is to count the records of one column by grouping them and to simply pass another column to the next transformer for further formatting. I have a transformer from where 2 columns are there say A & B.Next an aggregator is used to count the no of rows of c...