DSXchange

It is just an intuition but I get a strong feeling like it has to do something with trimming and null handling ... Check the columns where you do null handling along with trimming ...

Dont ask me why, I dont know ...

Hi Everybody, I need help on urgent basis and i would be greatful if you can provide me the solution. I have some tables where the no. of records is very huge and i want to do an incremetal load for them. The criteria for this is Selecting the Records after a specified Date. Now the value of this D...

Hey Balaji, I got a similar error in a job a month or so ago, but I was giving some complex conditions on the constraint. When I broke up those and saved them to stage variables it was working. One more question, are you using Nullhandling functions along with trim? I am also curious to know what is...

hi all, i am using 4 join stages sequentially ,the join lookup is same table for 4 joins and key column also same and i am using the left outer join on 4 joins and 4 joins are produced same column as output.i got output proper but the problem is it is generating the warnings like......... JoinNZMIS...

Hi Kumar, Really thanx for the information can you please let me know is there any Env Var to increase the Commit Interval in oracle Stage and how to do that while using Oracle stage in DS 7.5.1A PX and what extractly Insert Array Size does. Regards Srireddy. APT_ORAUPSERT_COMMIT_ROW_INTERVAL APT_O...

chulett wrote:Oddly enough, the StringToDate function.

That hits the bull's eye

Thanks for all the replies. I am currently defining every column as char and converting each and every column to char, I was just wondering, if i can avoid these conversions that would be very helpful. There is no way to write a Varchar directly without using a modify or transformer to a fixed width...

It was a document compiled by one person in my organization. I am skeptical about this argument anyway.

I want to make sure because, if this is valid, a lot of jobs needs has to be modified.

Thanks for ur valuable inputs Nagesh

Is there a way in which I can populate the Fixed width file with Varchar and Integer fields padding them with space beyond their length?

It seems stupid, but if there is a way, I would be able to save a lot of stages.

Thanks in advance,
Ajith

I got a document on DS EE best practices, It says about modify stage "3.3.7 Modify stage After DataStage release 7.5.1, Transformer stage performs better than Modify stage even for simple null handling operations. Moreover Modify stage breaks the metadata link between the stages. So it is not r...

It's tricky in a parallel job since each instance of the key generator will end on a different number, if you try to retrieve it in a transformer you will get a different answer for each node. Your problem is fixed in DataStage 8 which has settings for storing the surrogate key values in a file so ...

Just see in which stage are you getting this error message

I think that would give you more information


If that is on the sequential file stage, yeah it must be because of the delimiter problem as you would have guessed.

How to get the number of rows processed by surrogate key generator stage,
I want to write this into a file in the same job.

any ideas on this?

yeah thanks for ur reply.. i want do develop the logic for the business logic" If incoming date is older than 5 years then reject" My Approach--> first i have converted the incoming date into julian day and then i have done the difference between the julian days of incoming and the curren...

hi all, how to calculate the "Age of a person" or "difference b/w dates" using the datastage functions ThanksinAdvance Boppana Krishna Difference between dates can be found by converting the dates to Julianday and finding out the difference between them. But then finding out the...